In the majority of cases when you issue a SQL select statement you will want to return particular rows from a table. In other words, you generally do not want to select all rows from your table. The "where" clause allows you to indicate the criteria for what rows to display on your report, or output.
To learn how to use the where clause and its associated operator symbols on an SQL select statement, follow these steps:
Citiestable. Execute the following statement:
=(equal) operator symbol is used to indicate we are only interested in cities with a state abbreviation of 'CA'.
<>(not equal) operator symbol is used to indicate we are interested in cities whose state abbreviation is not equal to 'CA'.
>(greater than) operator symbol is used in the where clause. As you might suspect, other operator symbols are available such as
<=(less than or equal to) and
>=(greater than or equal to).