Advertisement
DimitarVasilev

Untitled

Jul 11th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.26 KB | None | 0 0
  1. SELECT DISTINCT k.*
  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) k
  6. WHERE rownum <= 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement