create table tablerepeat ( ID INT , ID2 INT )INSERT INTO tablerepeat SELECT 1,1 UNION ALL SELECT 1,2 UNION ALL SELECT 1,3 UNION ALL SELECT 2,1 UNION ALL SELECT 2,2 UNION ALL SELECT 2,3 UNION ALL SELECT 3,1 UNION ALL SELECT 3,2 UNION ALL SELECT 3,3SELECT A.* FROM tablerepeat A WHERE NOT EXISTS(SELECT ID ,ID2 FROM tablerepeat B WHERE B.ID2 >B.ID AND A.ID=B.ID AND A.ID2 = B.ID2) 1 1 2 1 2 2 3 1 3 2 3 3
(
ID INT ,
ID2 INT
)INSERT INTO tablerepeat
SELECT 1,1 UNION ALL SELECT
1,2 UNION ALL SELECT
1,3 UNION ALL SELECT
2,1 UNION ALL SELECT
2,2 UNION ALL SELECT
2,3 UNION ALL SELECT
3,1 UNION ALL SELECT
3,2 UNION ALL SELECT
3,3SELECT A.* FROM tablerepeat A WHERE NOT EXISTS(SELECT ID ,ID2 FROM tablerepeat B WHERE B.ID2 >B.ID AND A.ID=B.ID AND A.ID2 = B.ID2)
1 1
2 1
2 2
3 1
3 2
3 3