Jun 27, 2012

How to Search Duplicate Records in SQL



SELECT catrefcode, COUNT(*) TotalCount
FROM importedcatref
GROUP BY catrefcode
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC


By

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

What is the use of n-tier architecture and 3-tier architecture?

how to implement 3-tier architecture in asp.net using c#. 3-Tier architecture is also called layered architecture. Some people called it ...