Select * from [LVATCaseDesc] where convert(varchar, [DBId]) + '-' + [GroupName] + '-' + convert(varchar, [Ref]) + '-' + [Case] + '-' + [Description] in (Select convert(varchar, [DBId]) + '-' + [GroupName] + '-' + convert(varchar, [Ref]) + '-' + [Case] + '-' + [Description] as [ResField] from [LVATCaseDesc] Group by [DBId], [GroupName], [Ref], [Case], [Description] having count(*) > 1)
