How to Find Duplicate Records in SqlServer Table

1.How to Find Duplicate Records in Table ?

Select ColumnName From TableName
group by ColumName
having count(ColumName)>1
order by ColumName