how to cut out certain range in SQL table?

1539 views sql
2

i would like to copy certain range in SQL table and input into new table,and i have a look with some forum and some SQL tutorial website , mostly they are using BETWEEN STATEMENT but this only can use in single condition.and my condition is copy the certain range with 2 condition such as start copy with specific part number and end with type that is "A" but this data must be after ,so it can be a range.

Thanks All.

answered question

What is your SQL technology? Post data table examples and data examples

1 Answer

11

You can use and for multiple filters.

SELECT ...
FROM TABLE_NAME
WHERE CONDITION1 AND CONDITION2

For example

SELECT name
FROM People
WHERE age > 16 and home_town = 'New York City'

posted this

Have an answer?

JD

Please login first before posting an answer.