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 sql*loader and what is it used for?

575

What are the types of sql commands?

546

How can we make an if statement within a select statement?

536

What company owns postgresql?

560

What is a crud api?

493

Explain aggregate functions are available there in sql?

532

what is a tablespace? : Sql dba

560

What is synonyms?

570

How can check sql version from command line?

529

what is myisam? : Sql dba

573

What is a record in a database?

559

Is pl sql different from sql?

527

How do you remove duplicate records from a table?

509

What are the rules to be applied to nulls whilst doing comparisons?

750

Can you upgrade sql express to full sql?

512