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 store pictures on to the database?

924

How to create a server parameter file?

1081

Why oracle is used?

998

How to create a table index?

1063

How to pass a cursor variable to a procedure?

1042

what is reindexing?

1611

Explain what are the type of synonyms?

1057

How to delete an existing row from a table in oracle?

1019

What are the ansi data types supported in oracle?

898

Can we create database in oracle using command line ?

1031

What is Reduced List of Values?

2105

How can I see all tables in oracle?

951

How to change program global area (pga) in oracle?

1034

How to define an oracle sub procedure?

1058

Give the advantages and disadvantages of clusters.

997