DELETE FROM (SELECT EMP_ID, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DE

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

Question Posted / khan

Answer Posted / khan

DELETE FROM
(SELECT EMP_ID, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS CNT FROM EMPLOYEE)
WHERE CNT = 3;

Is This Answer Correct ?

9 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Where do we use decode and case statements?

945

Why do we use bulk collect in oracle?

1012

How to display employee records who gets more salary than the average salary in the department?

1002

What is the difference between translate and replace?

1013

How to start an oracle instance?

955

What are the major difference between truncate and delete?

988

What happens if variable names collide with table/column names?

1108

How do you store pictures in a database?

955

What privilege is needed for a user to query tables in another schema?

922

What is logical backup in oracle?

969

What is a lookup table in oracle?

934

How to create a new oracle data file?

974

How to create a new view in oracle?

1018

How to drop a stored function?

1087

What is data block in Oracle?

1052