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 the report builder?

139

What are the types of sql server?

1042

What are user defined functions in ms sql server?

987

Which table keeps the locking information?

913

What is difference statement and preparedstatement?

976

How to create user defined functions with parameters?

1216

What is the difference between count and distinct count?

877

What are types of storage modes? : sql server analysis services, ssas

1024

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

951

How can you check the level of fragmentation on a table?

1037

What is stored procedures?

1017

application server is slow what may be the problem

2212

Explain isolation levels that sql server supports?

1027

How to return the second 5 rows in ms sql server?

1050

Please illustrate physical database architecture? : SQL Server Architecture

974