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