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