Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- with emails as(
- select '1' id, 'work' email_type, 'abc@gmail.com' email from dual union all
- select '2' id, 'work' email_type, '123@yahoo.com' email from dual union all
- select '2' id, 'personal' email_type, '456@msn.com' email from dual union all
- select '3' id, 'personal' email_type, 'test@work.com' email from dual
- )
- id email_type email
- 1 work abc@gmail.com
- 2 work 123@yahoo.com
- 3 personal test@work.com
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement