Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.

Interview Candidate
Oct 13th, 2004
4
2622

Showing Answers 1 - 4 of 4 Answers

mahadev mahajan

Sep 30th, 2005

where clause is use to extrct only one record.it is used with GROUP BY CLAUSE.
     EG:-SELECT DNO FROM EMP WHERE SAL=4200
            GROUP BY DNO;
DISCRIPTION:- where dno is (dept. no) emp is (employi table),
                        here we are retriving dept.no whose salary is 4200
                        & these dept no's are arrenged in acending order.

Srinivas17738
Profile Answers by Srinivas17738

Aug 17th, 2010

1. WHERE clause is used to filter the result set records with different predicates like -- BETWEEN, =, <=, >= and many more....2. WHERE Clause is used to Isolate rows.