sql server select * from table where columns in list

Question

My table:

id	ppvnid	varid	prdid	partnerid
19	8	1	9	1
20	8	3	9	1
21	8	5	9	1
22	10	1	9	1
23	10	3	9	1
24	10	6	9	1

Answer 1

Looking at your input and output, possibly you want

Select ppvnid
from table
where varid in (1,3,5)
  and prdid=9
  and partnerid=1
group by partnerid,
         PrdId,
         ppvnid 
having count(distinct varid )=3