I have a SQL Server database of organizations, and there are many duplicate rows. I want to run a select statement to grab all of these and the amount of dupes, but also return the ids that are associated with each organization.

I deleted the duplicate records from Table. After sometime the duplicate counts, for the same records are increasing.

I deleted the duplicate records from Table.After sometime the duplicate counts ,for the same records are increasing.