In this chapter, you learn how to use the
WHERE clause to specify search conditions.
Database tables usually contain large amounts of data, and you seldom need to retrieve all the rows in a table. More often than not, you want to extract a subset of the table’s data as needed for specific operations or reports. Retrieving just the data you want involves specifying search criteria, also known as a filter condition.
SELECT statement, data is filtered by specifying search criteria in the
WHERE clause. The
WHERE clause is specified right after the table name (the
FROM clause) as follows:
SELECT prod_name, prod_price FROM products WHERE prod_price = 2.50;
This statement ...