Learn SQL Database Programming

Syntax for filtering data

To limit results using WHERE, you can use the following sample syntax:

SELECT col1, col2 FROM tablenameWHERE condition(s);

To limit results using AND with WHERE, you can use the following sample syntax:

SELECT col1, col2 FROM tablenameWHERE condition AND condition;

To limit results using OR with WHERE, you can use the following sample syntax:

SELECT col1, col2 FROM tablenameWHERE condition OR condition;

To limit results using IN with WHERE, you can use the following sample syntax:

SELECT col1, col2 FROM tablenameWHERE col1 IN (values);

To limit results using NOT IN with WHERE, you can use the following sample syntax:

SELECT col1, col2 FROM tablenameWHERE col1 NOT IN (values);

To limit results using BETWEEN ...