SQL - Structured Query Language

WHERE Clause



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



* * * * *


Email Your Comment To AUTHOR