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

6. Display the client name and order date for all orders using the traditional method.

2364

What is a initialization parameter file in oracle?

1087

How to grant create session privilege to a user in oracle?

1055

When do I need to use a semicolon vs a slash in oracle sql?

1147

How to establish administrator authentication to the server?

1098

What is Virtual Private Database in Oracle?

1151

How many data types are supported?

1140

How to define a specific record type?

1138

Explain parameter file in oracle.

1082

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2208

What is the difference between I and G in Oracle?

1152

Explain oracle’s server parameter file.

1041

What are triggers in oracle?

1100

Why do you create or replace procedures rather that drop and recreate.

1070

Explain the use of constraints option in exp command.

1083