Find Duplicates From a Table in SQL Server

 

Select id,name,tel from table1

where name In (Select name from table1 Group by name having (Count(*)>1))

ORDER BY Name