Select * from [LVATGroup] where convert(varchar, [DBId]) + '-' + [Name] in (Select convert(varchar, [DBId]) + '-' + [Name] as [ResField] from [LVATGroup] Group by [DBId], [Name] having count(*) > 1)