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

Does user triggers have entry for trigger with compilation errors?

1034

What is the usage of nvl function?

1040

how to include character strings in sql statements? : Sql dba

1071

What is update query?

980

how does a local variable is defined using t-sql? : Transact sql

1012

What is the difference between row level and statement level trigger?

1021

What normalization means?

977

What is row_number () in sql?

979

What do you understand by pl/sql cursors?

1086

Is sql low level language?

1018

What is denormalization in a database?

1053

Are stored procedures faster than dynamic sql?

1039

What is cross join example?

1000

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1187

How do I install microsoft sql?

1050