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 the difference between jpql and sql?

1147

what are sequences

1824

What is recursive stored procedure?

1142

Does postgresql run on the cloud?

1223

How to download oracle sql developer?

1167

What is a sql statement?

1019

Is primary key always clustered index?

1067

how many values can the set function of mysql take? : Sql dba

1039

how to dump a table to a file with 'mysqldump'? : Sql dba

1103

What company owns postgresql?

1092

What are the rules to be applied to nulls whilst doing comparisons?

1370

Can we use view in stored procedure?

956

What are the different schemas objects that can be created using pl/sql?

1085

Is sql sequential or random?

1086

Can we insert in view in sql?

1107