Hi Agness,

How about

SELECT C3 FROM (SELECT DISTINCT C1, C2, C3 FROM Schnaps)  X GROUP BY C3 HAVING COUNT(*) > 1

and

SELECT * FROM Schnaps WHERE C3 IN (SELECT C3 FROM (SELECT DISTINCT C1, C2, C3 FROM Schnaps)  X GROUP BY C3 HAVING COUNT(*) > 1)

Walter,

>Hi All,
>
>I have a SQL problem I have no idea if I can solve it with one select (I can do with two, but this is not what i like to have)
>
>The problems comes from an import scenario.
>
>I have a table like
>

>c1   c2  c3 ...
>A    a    1
>A    b    2
>A    b    3
>B    c    4
>B    d    4
>A    b    3
>

>
>For a given c3 the combination of c1 and c2 should be the same. We can see that for c3=4 this is not true.
>
>How do I code a single SELECT SQL that returns just
>
>

>c1   c2  c3
>B    c    4
>B    d    4
>

>
>and
>
>

>c3
>4
>

>
>
>TIA
>
>Agnes