delete from emp e1 where n = (select count(distinct rowid) fro

How will you delete a particular row from a Table?

Question Posted / rakesh

Answer Posted / rakesh

delete from emp e1
where n = (select count(distinct rowid)
from emp e2
where e2.rowid <= e1.rowid)

Note:Here "n" means Nth row..

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many primary keys can a table have?

1005

What is triggering circuit?

1062

what is user defined functions? : Sql dba

1027

Are subqueries faster than joins?

1016

Why is %isopen always false for an implicit cursor?

1100

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1434

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1054

Can we commit inside a trigger?

987

What is sql mysql pl sql oracle?

1067

What is the use of %rowtype?

1034

How to read/write files from pl/sql?

1035

What is dynamic query?

968

What is dba in sql? : SQL DBA

1037

Is foreign key mandatory?

998

explain commit and rollback in mysql : sql dba

1009