|SQL - Structured Query Language|
WHERE clause is used to retrieves set of record(s) from the particular table by using unique expression. The expression is record(s) filter condition that contain Column Name + Operator + Filter Data Value. Expression is called criterion and set of expressions are called criteria. The following SQL queries are used to retrieves set of record(s) from PRODUCT Table.
-- Example 26 --
SELECT * FROM Product
SELECT * FROM Product WHERE Prod_Tax = 15
SELECT * FROM Product WHERE Prod_Code = 'PROD4'
SELECT * FROM Product WHERE Exp_Date = '12/31/2007'
Query Output Screen
* * * * *