You are here:

MS SQL/SQL query to fetch duplicate data only

Advertisement


javanme wrote at 2012-12-18 05:42:54
As per my experience it started get tricky when you have more than one column which defines uniqueness, its important to include both of them in group by clause as shown in this sql query to find duplicate records in table , leaving any one of them will result in incorrect result set.


MS SQL

All Answers


Answers by Expert:


Ask Experts

Volunteer


Jwalant Natvarlal Soneji

Expertise

Questions related to query optimization, finding complex results.

Experience

Experience in the area: I have been working in the field since 2005 year. Education/Credentials: BE IT, First Class, 2005 Batch.

Publications
http://jwalantsoneji.com

Education/Credentials
BE IT, India

Awards and Honors
MCP

©2016 About.com. All rights reserved.