Guest User

Untitled

a guest
May 23rd, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. ID Name Gender Country
  2. 1 Jhon Male USA
  3. 2 Katie Female USA
  4. 3 Steave Male UK
  5. 4 Gerry Female UK
  6. 5 Brad Male AUS
  7.  
  8. select t.*
  9. from table t
  10. where not exists (select 1
  11. from table
  12. where Country = t.Country and
  13. Gender = 'Female'
  14. );
Add Comment
Please, Sign In to add comment