Having keyword basically similar to if condition Only returns true conditions SELECT FIRST_NAME , COUNT(*) FROM EMPLOYEES GROUP BY FIRST_NAME HAVING COUNT(*) > 1