DELETE FROM emp WHERE empno = (SELECT empno

How to Remove the 3rd highest salary person record from
table?

Question Posted / nathan

Answer Posted / nathan

DELETE FROM emp
WHERE empno = (SELECT empno
FROM (SELECT empno, ROWNUM rn
FROM (SELECT empno
FROM emp
ORDER BY sal DESC))
WHERE rn = 3);

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Please explain oracle data types with examples?

1061

how the indexes are stored in the Oracle Database?

2269

What are the various oracle database objects?

1142

What is the difference between view and materialized view in Oracle?

1148

What are the differences between number and binary_float in oracle?

1098

Define oracle database

1040

How to define a sub function?

1127

How to use existing values in update statements using oracle?

1064

Please explain joins in oracle?

1059

How to start a new transaction in oracle?

1082

How a tablespace is related to data files?

1106

What is the difference between translate and replace?

1055

Which is better Oracle or MS SQL? Why?

6381

What is a initialization parameter file in oracle?

1034

How oracle handles dead locks?

1064