how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
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 |
Post New Answer View All Answers
Define overloaded procedure?
What is the usage of the distinct keyword?
What is the current version of sql?
What is bulk compiling in pl/sql.?
how many sql ddl commands are supported by 'mysql'? : Sql dba
When to use inner join and left join?
Does sql backup shrink transaction log?
What is the maximum rows in csv?
What is a call statement? Explain with an example.
What is difference between cursor and trigger?
what is offset-fetch filter in tsql? : Transact sql
What is linq to sql?
What are the benefits of triggers?
What is triggering circuit?
What is t sql used for?