ETL Testing - Find Duplicate Value

How to find no of duplicate value in column?
  • Interview Candidate
  • 3
  • 6157

Showing Answers 1 - 3 of 3 Answers

Sidd

  • Mar 19th, 2016
 

Code
  1. SELECT col_name ,count (*) FROM table_name GROUP BY col_name HAVING count(*)>1

  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