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 to fetch alternate records from a table?

1224

Explain cursor types?

1018

What is flag in sql?

1028

Can we change the table name in sql?

937

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

964

Is left join and outer join same?

1052

What is assignment operator in pl sql?

1028

How can I change database name in sql?

1068

What is sql deadlock?

1127

What is cursor and its types?

1059

Explain what is a field in a database and record in a database?

1089

What is left join example?

940

Why do we use cursors?

984

How do you modify a column in sql?

987

Is sql database free?

964