1.

What is the difference between where and having clause ?

Answer»
WHERE CLAUSEHAVING CLAUSE
Places conditions on individual rowsPlaces conditions on groups.
Cannot include aggregate function.Can include aggregate function.
For eg. SELECT * FROM student WHERE Rno >=10;For eg. SELECT AVG(marks) FROM student GROUP BY grade HAVING grade = ‘B1’;


Discussion

No Comment Found

Related InterviewSolutions