ETL Testing - Find Duplicate Value

How to find no of duplicate value in column?

Showing Answers 1 - 1 of 1 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