delete from emp where sal >(select max(sal) from emp where sal >(sel

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

Question Posted / krishna

Answer Posted / krishna

delete from emp where sal >(select max(sal) from emp where
sal >(select max(sal) from emp where sal >(select max(sal)
from emp)));

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to create a stored function in oracle?

1104

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

Explain the dml?

974

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1897

How to assign values to data fields in record variables?

1029

How to drop a tablespace?

1042

What would you do with an in-doubt distributed transaction?

1975

What is a partition in oracle?

1117

Explain what are clusters?

1106

What are the differences between char and varchar2 in oracle?

1165

How do I find my oracle client driver version?

1038

What is BBED in Oracle?

1150

How to use an explicit cursor without open statements?

1051

How to login to the server without an instance?

1159

How to start instance with a minimal initialization parameter file?

1036