Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ID Name Gender Country
- 1 Jhon Male USA
- 2 Katie Female USA
- 3 Steave Male UK
- 4 Gerry Female UK
- 5 Brad Male AUS
- select t.*
- from table t
- where not exists (select 1
- from table
- where Country = t.Country and
- Gender = 'Female'
- );
Add Comment
Please, Sign In to add comment