delete from employee where sal = (select sal from (select sal from employee

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

Question Posted / manoj

Answer Posted / manoj

delete from employee where sal = (select sal from (select sal from employee order by sal desc) where rownum = 3);

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain enable novalidate constraint.

1035

How to update values on multiple rows in oracle?

975

Explain the use of record option in exp command.

949

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2211

Is the After report trigger fired if the report execution fails ?

2879

How to use null as conditions in oracle?

1003

How to convert a date to char in oracle? Give one example.

1003

How to count groups returned with the group by clause in oracle?

1012

What is raw datatype in oracle?

1052

How do I connect to oracle?

977

How to use values from other tables in update statements using oracle?

1026

Is oracle a relational database?

871

How to check database size in Oracle?

1119

How to do paging with oracle?

950

How to retrieve data from an cursor to a record?

1019