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 types of views in sql?

1103

Explain the commit statement.

1163

Which sql statement is used to return only different values?

1008

what are the drivers in mysql? : Sql dba

1025

What is the life of an sql statement?

1024

How do I remove sql plus from windows 10?

1105

What is the advantage of nosql?

1061

Does inner join return duplicate rows?

981

How many databases can sql express handle?

989

What is pl/sql language case sensitive?

1131

how to analyze tables with 'mysqlcheck'? : Sql dba

1014

What does select top 1 do in sql?

1102

What does the acronym acid stand for in database management?

1032

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3053

what is cursor. write example of it. What are the attributes of cursor.

1395