Query to get rows containing exact column values for Group in SQL Server

Question

I have a sql table where I want to get GroupName having exact Variants in the tableGroupNameVariantIDGRP724141GRP724142GRP724143GRP724144GRP724522GRP724523GRP724731like if i search for group name having variant id 23 then it should show only GRP72452I want to search group name who have exact those variants like GRP72452 have exact 23 but GRP72414 have 123 in itSo if I search for Variant ID 1 then result should be GRP72473 because that group have only one vari

abhi619 · Accepted Answer

Got the queryselect GroupNamefrom VariantGroups as tgroup by GroupNamehaving sumcase when VariantID  1 then 1 else 0 end gt 0 and       sumcase when VariantID  2 then 1 else 0 end gt 0 and       sumcase when VariantID  3 then 1 else 0 end gt 0 and       sumcase when VariantID not in 12 3 then 1 else 0 end  0

GroupName	VariantID
GRP724_1_4	1
GRP724_1_4	2
GRP724_1_4	3
GRP724_1_4	4
GRP724_5_2	2
GRP724_5_2	3
GRP724_7_3	1

Query to get rows containing exact column values for Group in SQL Server

Company

Explore

Follow us

Contact Us