Sunday, 1 November 2015

How to delete duplicate row in Sql Server?

How to delete duplicate row in Sql Server? Here i use only name column select * from student1 order by name,age id          name                  age ----------- --------------------- ----------- 7           Ramu Kumar            30 14          Sachi Supriya      ...