I was looking at the forums and my mail box, the big question that every bods asks me is how to find out the duplicate records.
this is the answer for this query.
SELECT
FROM
tablename
GROUP BY
HAVING
count(*) > 1
Sunday, February 17, 2008
Duplicate Records
Subscribe to:
Post Comments (Atom)
1 comment:
Simple query..can u tell me what is the equivalnet of ROWid in SQL Server
Post a Comment