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', 'd', '4') insert into Schnaps values ('A', 'b', '3')second question :
select c3 ; from Schnaps ; group by 1 ; having ( count( distinct c1 + c2 ) > 1) ;First question :
select S.* ; from Schnaps S, ; ( ; select c3 ; from Schnaps ; group by 1 ; having ( count( distinct c1 + c2 ) > 1) ; ) AA ; where ( S.c3 == AA.c3 )
>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
>
>