Wednesday, December 1, 2021

Group By with having clause

 SELECT COUNT(ID) FROM EMPLOYEE GROUP BY NAME HAVING COUNT(ID)>1


having is used with group by and count.

No comments:

Post a Comment