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

Explain ttitle and btitle.

1056

What does (*) mean in sql?

903

How do I find duplicates in two columns?

1056

Is sql difficult?

1104

What are pl/sql packages?

1035

Is primary key is clustered index?

937

Can we use update in sql function?

1005

what is rollback? : Sql dba

1021

How do I create an index in word?

965

what is a cursor? : Sql dba

972

Can we create table in function?

907

What is cost in sql execution plan?

902

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1005

What is difference between joins and union?

1042

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

969