create cursor Schnaps ; ( c1 c(1), ; c2 c(1),; c3 c(1) ; ) insert into Schnaps values ('A', 'a', '1') insert into Schnaps values ('A', 'b', '2') insert into Schnaps values ('A', 'b', '3') insert into Schnaps values ('B', 'c', '4') insert into Schnaps values ('B', 'c', '4') insert into Schnaps values ('B', 'd', '4') insert into Schnaps values ('B', 'e', '4') && added insert into Schnaps values ('B', 'e', '4') && added insert into Schnaps values ('B', 'f', '4') && added insert into Schnaps values ('A', 'b', '3') *!* select T.* from Schnaps T INNER JOIN ; *!* (SELECT c3, MIN(c1) as c1_min,MAX(c1) as c1_max, ; *!* MIN(c2) as c2_min, MAX(c2) as c2_max FROM Schnaps X group by 1 ; *!* HAVING COUNT(distinct(c1+c2)) > 1) X ON T.c3= X.c3 select S.* ; from Schnaps S, ; ( ; select c3 ; from Schnaps ; group by 1 ; having ( count( distinct c1 + c2 ) > 1) ; ) AA ; where ( S.c3 == AA.c3 ) SELECT * FROM Schnaps WHERE C3 IN (SELECT C3 FROM (SELECT DISTINCT C1, C2, C3 FROM Schnaps) X GROUP BY C3 HAVING COUNT(*) > 1)>Hi Agness,
SELECT C3 FROM (SELECT DISTINCT C1, C2, C3 FROM Schnaps) X GROUP BY C3 HAVING COUNT(*) > 1>
SELECT * FROM Schnaps WHERE C3 IN (SELECT C3 FROM (SELECT DISTINCT C1, C2, C3 FROM Schnaps) X GROUP BY C3 HAVING COUNT(*) > 1)>
>>c1 c2 c3 ... >>A a 1 >>A b 2 >>A b 3 >>B c 4 >>B d 4 >>A b 3 >>>>
>>c1 c2 c3 >>B c 4 >>B d 4 >>>>
>>c3
>>4
>>
>>