How to identify duplicate values in a database

SELECT     programme_main_id
FROM         dbo.para_sub_details
GROUP BY programme_main_id
HAVING      (COUNT(programme_main_id) > 1)

This uses a simple SQL statement which identifies those entries which have dupliate programme_main_id

Paul

Leave a Reply