Job

********* REFRESH YOUR TECHNICAL KNOWLEDGE**********

Friday, June 14, 2013

How to find duplicate records in a table

SELECT
<list of all columns>
FROM
tablename
GROUP BY
<list of all columns>
HAVING
Count(*) > 1
Posted by Venkat at 12:34 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)