KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
col1 col2 A bear A dog A cat B bear B dog B cat C dog C cat D bear D dog D cat E bear E dog E cat F dog F cat if I wanted to select all of the col1 values that have at least one row where col2 = 'bear' , I can do: SELECT col1 FROM mytable WHERE col1 IN ('A','B','C') GROUP BY col1 HAVING col2 = 'bear' which would return A and B but I want to select only the values from col1 where there isn't a row where col2 = 'bear' I'm thinking NOT HAVING , but that doesn't appear to work. any ideas? thanks!
Tags (comma-separated)
Save Edits
Cancel