SQL to return if a single row(can be>1) and certain criteria

[andrewRA]

Not sure how to approach this as I keep going in circles. I want to return ID's that soley have keyword='ISV' and no other keyword. I tried some count(*)=1 and 'GROUP BY' but it does not seem to work.

Example Table

id keyword
== =======
A ISV
A Reseller
A Foo
B ISV
C ISV
D Foo
D ISV

So the desired result would just id of B,C while A,D are ignored because they have additional keywords.

Thanks for any direction.

 

[swampBoogie]

select id 
  from t 
  group by id
  having sum(case when keyword = 'ISV' then 0 else 1 end) = 0

 

[ManivannanD]

The Following query is Generic Query, you can do it for any keyword,

Select Distinct ID, KeyWord
From
(
Select
ID,
KeyWord,
(Select Count(Distinct KeyWord) From Ta Sub Where Sub.Id = Main.Id) KeyWordCount
From
Ta Main
) as Data
Where
KeyWord = 'ISV'
And KeyWordCount = 1