Interview Questions   Tutorials   Discussions   Programs   Videos   

SQL - select statement to find duplicates on certain fields




618
views
asked mar January 10, 2014 06:40 AM  

select statement to find duplicates on certain fields


           

1 Answers



 
answered By mar   0  

To get the list of fields for which there are multiple records, you can use..

select field1,field2,field3, count(*)
  from table_name
  group by field1,field2,field3
  having count(*) > 1
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  Question tags

sql × 1

Asked 4 years and 9 months ago ago
Number of Views -618
Number of Answers -1
Last updated
4 years and 9 months ago ago

  Similar questions


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert