SQL Tips: How to detect duplicate rows in table

For example:

-- O: Original table
-- D: Duplicate records table

select O.*,  D.RecCount
from tblFunctionality O
inner join 
(
	select FunctionalityName, IsGroup, ParentId, COUNT(*) AS RecCount
	from tblFunctionality 
	group by FunctionalityName, IsGroup, ParentId 
	having COUNT(*) > 1
) D
on 
	O.FunctionalityName = D.FunctionalityName AND 
	O.IsGroup = D.IsGroup AND 
	O.ParentId = D.ParentId
order by O.FunctionalityName, O.IsGroup, O.ParentId;