Find number of duplicates with different case fields

By Greg April 24, 2018

1 Min Read

SQL query to find duplicate entries, even if the case is different.

SELECT COUNT(*) as cnt, ParentId, UPPER(Name)
FROM TREE
GROUP BY ParentId, UPPER(Name)
HAVING cnt > 1

Categorized in:

SQL,

Last Update: May 18, 2024