• Infact, I didin't understand why you wrote like that code.

    Where is the difference from below code.

    I think It's very easy.

    SELECT * FROM t1 WHERE y IN (

    SELECT y FROM t1

    GROUP BY y

    HAVING COUNT(y)>1

    )

    Thanks.