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

How to drop a stored procedure in oracle?

592

How to run create database statement?

585

Who developed oracle & when?

577

Explain oracle insert into command?

637

What is a data lock in oracle?

619

What are the different oracle database objects?

592

What are the original export and import utilities?

578

What is a data dictionary and how can it be created?

622

How to empty your oracle recycle bin?

579

Please explain drop constraint oracle?

634

What are the oracle built-in data types?

570

Explain implicit cursor.

565

Explain rename?

562

How to calculate date and time differences in oracle?

540

What is the difference between primary key and unique key and foreign key in oracle?

558