Advertisement
Guest User

Group By

a guest
Aug 21st, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1.   SELECT *
  2.   FROM ProductFilter
  3.   WHERE Id NOT IN
  4.   (
  5.     SELECT Id
  6.     FROM ProductFilter P
  7.     INNER JOIN
  8.     (
  9.      SELECT FieldId, OrgElement
  10.      FROM ProductFilter
  11.      GROUP BY FieldId, OrgElement
  12.      HAVING  COUNT(*) = 1
  13.     ) T
  14.     ON P.FieldId =T.FieldId AND P.OrgElement = T.OrgElement
  15.   )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement