SQL Find duplicate sets
Posted
by
Aheho
on Stack Overflow
See other posts from Stack Overflow
or by Aheho
Published on 2013-11-07T15:34:46Z
Indexed on
2013/11/07
15:53 UTC
Read the original article
Hit count: 220
sql
|sql-server-2008-r2
given this Schema:
table tblSET
SetID int PK
SetName nvarchar(100)
Table tblSetItem
SetID int PK
ItemID int PK
tblSetItem.SetID is a FK into the tblSet Table.
Some data:
tblSet
SetID SetName
1 Red
2 Blue
3 Maroon
4 Yellow
5 Sky
tblSetItem
SetID ItemID
1 100
1 101
2 100
2 108
2 109
3 100
3 101
4 101
4 108
4 109
4 110
5 100
5 108
5 109
I'd like a way to identify which sets contain the same items. In the example above Red and Maroon contain the same items (100,101) and Blue and Sky contain the same values (100,108,109)
Is there a sql query which would provide this answer?
© Stack Overflow or respective owner