Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT k.*
- FROM (SELECT UPPER(first_name), UPPER(last_name) FROM person
- WHERE UPPER(first_name) IN (SELECT DISTINCT UPPER(first_name) FROM person)
- AND UPPER(last_name) IN (SELECT DISTINCT UPPER(last_name) FROM person)
- ORDER BY 1) k
- WHERE rownum <= 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement