Delete from table name where row_id not in (select min(no) from table

how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Question Posted / pratap

Answer Posted / pratap

Delete from table name where row_id not in (select min(no)
from table_name group by no)

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is consistency?

1061

what tools available for managing mysql server? : Sql dba

1008

what is commit? : Sql dba

1026

What is bulk collect in pl sql?

1019

Are subqueries faster than joins?

949

What are the two characteristics of a primary key?

926

What is the current version of sql?

972

What is function and procedure in pl sql?

970

What does bitemporal mean?

1009

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

953

Why partition by is used in sql?

969

Is id a reserved word in sql?

1091

what are integrity rules?

964

The select into statement is most often used to create backup copies of tables or for archiving records?

1000

Why indexing is needed?

939