Friday, 4 April 2014

How to find the Duplicate Records in SQL



TO find out the duplicate records in SQL ,

How to find duplicate records:


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



How to Delete duplicate Records:






No comments:

Post a Comment

Please comment here