Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT *
- FROM ProductFilter
- WHERE Id NOT IN
- (
- SELECT Id
- FROM ProductFilter P
- INNER JOIN
- (
- SELECT FieldId, OrgElement
- FROM ProductFilter
- GROUP BY FieldId, OrgElement
- HAVING COUNT(*) = 1
- ) T
- ON P.FieldId =T.FieldId AND P.OrgElement = T.OrgElement
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement