Advertisement
Guest User

Untitled

a guest
Apr 4th, 2017
494
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. with emails as(
  2. select '1' id, 'work' email_type, 'abc@gmail.com' email from dual union all
  3. select '2' id, 'work' email_type, '123@yahoo.com' email from dual union all
  4. select '2' id, 'personal' email_type, '456@msn.com' email from dual union all
  5. select '3' id, 'personal' email_type, 'test@work.com' email from dual
  6. )
  7.  
  8. id email_type email
  9. 1 work abc@gmail.com
  10. 2 work 123@yahoo.com
  11. 3 personal test@work.com
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement