SQL - Structured Query Language

HAVING Clause



HAVING Clause is used with the GROUP BY clause to filter groups in the result set.

-- Example 29 --

 

SELECT COUNT(*), Prod_Tax FROM Product

GROUP BY Prod_Tax

HAVING COUNT(*) > 1

 

SELECT COUNT(*), Prod_Tax FROM Product

GROUP BY Prod_Tax

HAVING Prod_Tax = 15


Query Output Screen



* * * * *


Email Your Comment To AUTHOR