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