Where
Next: SQL AND OR
Next, we might want to conditionally select the data from a table. For example, we may want to only retrieve stores with sales above $1,000. To do this, we use the WHERE keyword. The syntax is as follows:
For example, to select all stores with sales above $1,000 in Table Store_Information,
Table Store_Information
| store_name | Sales | Date |
| Los Angeles | $1500 | Jan-05-1999 |
| San Diego | $250 | Jan-07-1999 |
| Los Angeles | $300 | Jan-08-1999 |
| Boston | $700 | Jan-08-1999 |
we key in,
SELECT store_name
FROM Store_Information
WHERE Sales > 1000
Result:
| store_name |
| Los Angeles |