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 the key differences between SQL and PL SQL?

1286

What is the difference between having and a where in sql?

1151

What are the different dml commands in sql?

1248

Differentiate pl/sql and sql?

1130

how to select first 5 records from a table? : Sql dba

1028

What is an alias command?

1119

What are all the common sql functions?

1084

Why cross join is used?

1135

State few characteristics of pl/sql?

1023

What are the basic techniques of indexing?

1112

what is a table in a database ? : Sql dba

1090

What are the advantages of sql? Explain

1154

What is sql character function?

1151

What do you understand by exception handling in pl/sql?

1088

What is a primary key example?

1002