Name : New Sno Name 1 Rajesh 2 Rajesh 3 Raja 4 Raja 5 A

how to delete duplicate rows from table

Question Posted / kumar.t

Answer Posted / kumar.t

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)

Is This Answer Correct ?

14 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is model database? : SQL Server Architecture

1192

Ms sql server index?

1104

How to stop a loop early with break statements in ms sql server?

1077

How can we use ConnectorJ JDBC Driver with MS SQL?

1053

Can an automatic recovery be initiated by a user?

1069

How to turn off warning messages during php execution?

1110

How to end a stored procedure properly in ms sql server?

1149

Explain the steps to create and execute a user-defined function in the sql server?

1016

What is difference between commit and rollback when used in transactions?

1019

What the difference between UNION and UNIONALL?

1091

What is compression - row-level and page-level compression?

965

How can I tell if sql server is 32 or 64 bit?

1014

application server is slow what may be the problem

2274

How to provide login information for a new odbc dsn?

1100

What is cursor in ms sql server?

1204