Home Forums Article Discussions Article Discussions by Author Discuss content posted by marcelo miorelli how to find duplicated rows in a table RE: how to find duplicated rows in a table
iskarta
SSC Enthusiast
Points: 139
More actions
June 18, 2008 at 1:41 am
#830242
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.