ETL Duplicate Records

How to find number of duplicate records?
  • Interview Candidate
  • 9
  • 7257

Showing Answers 1 - 9 of 9 Answers

Mitch Grout

  • May 2nd, 2016
 

Select distinct (primary key value) from table. Subtract from total number of records.

  Was this answer useful?  Yes

Harsha

  • Jun 10th, 2016
 

Code
  1. SELECT count(*),TABLE.* FROM TABLE GROUP BY ALL COLUMNS HAVING Count(*)>1

  Was this answer useful?  Yes

Swathi

  • Sep 26th, 2017
 

We can find the duplicates using SQL Query.

Code
  1. SELECT count(Field_NAME) FROM Table_name

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions