HAVING Clause

This is the least used clause. It is a filter clause, like the WHERE clause, and is only used after the GROUP BY has been done. For example, —GROUP BY CLAUSE —GROUP BY CLAUSE SELECT NAME, COUNT(*) AS Number_of_times FROM col$ WHERE COL# = 1 GROUP BY NAME HAVING COUNT(*) > 5;   USING THE […]

HAVING Clause Read More ยป