[Konstantin-78]

Вот тут еще вариант:

Код:

1 2 3 4 5 6 7 8 9

SELECT Q.proposal_id   FROM (     SELECT proposal_id, sort_work_id       FROM Devices       GROUP BY proposal_id, sort_work_id) Q   GROUP BY Q.proposal_id   HAVING Count(*)=2 AND SUM(CASE WHEN Q.sort_work_id IN (1,2) 1 ELSE 0 END)=2   //строгое     HAVING Count(*)>=2 AND SUM(CASE WHEN Q.sort_work_id IN (1,2) 1 ELSE 0 END)=2  //не строгое