|
|
|
| SQL - Structured Query Language |
WHERE ClauseWHERE 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 |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR