Interview Questions   Tutorials   Discussions   Programs   Videos   

SQL - select statement to find duplicates on certain fields




592
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 3 years and 11 months ago ago
Number of Views -592
Number of Answers -1
Last updated
3 years and 11 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