SELECT FROM WHERE GROUP BY HAVING code example

Example: having keyword sql

Having keyword basically similar to if condition
Only returns true conditions

SELECT FIRST_NAME , COUNT(*)
FROM EMPLOYEES 
GROUP BY FIRST_NAME
HAVING COUNT(*) > 1