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 is clause?

1156

what is blob? : Sql dba

1154

What does trigger mean in psychology?

963

What are the different sql commands?

1075

Is record in oracle pl sql?

968

What is parameter substitution in sql?

1033

What is the execution plan in sql?

1027

What are analytic functions in sql?

1030

What is the main difference between sql and pl/sql?

1101

Explain mutating table error.

1208

What are the events on which a database trigger can be based?

1190

What version is sql?

1037

Determine if oracle date is on a weekend?

1041

Is it possible to update views?

960

What is the difference between sql and t sql?

1042