Advertisement
DimitarVasilev

Untitled

Jul 11th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.25 KB | None | 0 0
  1. SELECT *
  2. FROM (SELECT UPPER(first_name), UPPER(last_name) FROM person
  3. WHERE UPPER(first_name) IN (SELECT DISTINCT UPPER(first_name) FROM person)
  4. AND UPPER(last_name) IN (SELECT DISTINCT UPPER(last_name) FROM person)
  5. ORDER BY 1)
  6. WHERE rownum <= 20
  7. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement