delete from employees where employee_id in (select employee

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

Question Posted / suresh babu

9 Answers
19388 Views
HCL, IBM, I also Faced
E-Mail Answers

Answer Posted / suresh babu

delete from employees where employee_id in (select
employee_id from employees where 3 =(select count(distinct
e.salary) from employees e
where e.salary >= employees.salary));

Is This Answer Correct ?

17 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the usage of analyze command in oracle?

1142

What are the system predefined user roles?

1100

Is rowid unique in oracle?

1048

What are the different types of synonyms?

1200

What is a proxy class?

1107

Can a formula column referred to columns in higher group ?

2553

How to use "in" parameter properly?

1120

How to get last row id?

1058

What is oracle analytical function?

1234

what is the difference between substr and instr function in oracle?

1143

How can I see all tables in oracle?

1061

How to get execution path reports on query statements?

1045

What are the execution control statements in oracle?

1133

How do I connect to oracle?

1080

What is Redo Log Buffer in Oracle?

1283