Skip to content

Instantly share code, notes, and snippets.

@artemrogov
Created June 23, 2018 16:04
Show Gist options
  • Save artemrogov/a97240eabd001870486de25aa43484fe to your computer and use it in GitHub Desktop.
Save artemrogov/a97240eabd001870486de25aa43484fe to your computer and use it in GitHub Desktop.
having.sql
select first_name, last_name, second_name, count(*)
from customers
group by first_name,last_name, second_name
having count(*) < 2
order by first_name, last_name, second_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment