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 are the three forms of normalization?

1034

How does a self join work?

1086

What does sql stand for?

978

Is primary key is clustered index?

988

What is exception? What are the types of exceptions?

1062

What are the different ddl commands in sql?

1140

Is sql sequential or random?

1016

What does count (*) mean in sql?

1560

What is pl sql block structure?

1019

What is full join in sql?

980

how to select first 5 records from a table? : Sql dba

966

Can we join two tables without common column?

991

Is foreign key mandatory?

992

What is the difference between count 1 and count (*) in a sql query?

971

How can I change database name in sql?

1054