Friday, February 26, 2010
How to find duplicate records in SQL Server?
2/26/2010 12:29:00 PM |
Posted by
VijayKumar Yadavalli
|
Edit Post
This is not a tuff job to do but recently one my friend asked me the same question and i replied with the following query.
SELECT SKUID, COUNT(SKUID) FROM SKURequests
GROUP BY SKUID
HAVING COUNT(SKUID) > 1
Even though it is very simple, i thought to share in my blog so it may help some one who needs it.
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(48)
-
▼
February
(15)
- How to find duplicate records in SQL Server?
- The product level is insufficient for component
- How to generate Data script from SQL Database
- JavaScript Frameworks/Libraries Side by Side Compa...
- How to Eliminate Merged Cells from a Reporting Ser...
- Top 10 VMware Performance Tweaks
- A nice article about Microsoft Windows Communicati...
- How to Delete SharedServices?
- Virtual Server Performance Tips
- How to Enable AHCI After Windows OS installation?
- How to find Your processor supports Virtualization...
- UnKnown PCI Simple Communications Controller
- Dynamically Change Environment Specific Web.Config...
- UNIX VS Linux
- Factory Method Pattern (Creational)
-
▼
February
(15)
0 comments:
Post a Comment