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
difference between anonymous blocks and sub-programs.
What is a function in oracle pl sql?
What is implicit cursor in pl sql?
Is primary key always clustered index?
What is inner join in sql?
What is natural join in sql?
Are stored procedures compiled?
How to sort the rows in sql.
How do I clear the screen in sql plus?
what is a record in a database ? : Sql dba
How to get each name only once from an employee table?
What is pessimistic concurrency control? : Transact sql
What is minus?
List different type of expressions with the example.
Does access use sql?