Name : New

Sno Name
1   Rajesh
2   Rajesh  
3   Raja
4   Raja
5   Arun
6   Bala

Delete From New Where Sno Not IN 
(Select Min(Sno) From New Group By Name)