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

what are numeric data types? : Sql dba

1028

What are user defined functions?

957

Is sql scripting language?

1000

What packages(if any) has oracle provided for use by developers?

5737

Can delete statement be rollbacked?

948

Can we call dml statement in function?

993

What are the built in functions of sql?

997

What is the difference between clustered and non-clustered index in sql?

973

how is exception handling handled in mysql? : Sql dba

1025

What are the 3 types of behavioral triggers?

1201

What is nosql vs sql?

1130

how to increment dates by 1 in mysql? : Sql dba

942

What is identity column in sql server?

1000

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1244

What are sql injection vulnerabilities?

929