select max(salary)from employees where salary

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

Question Posted / jainish

Answer Posted / jainish

select max(salary)from employees
where
salary < (select max(salary)from employees where
salary < (select max(salary) from employees))

Is This Answer Correct ?

4 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the difference between I and G in Oracle?

1092

How to turn on or off recycle bin for the session?

1103

What is a oracle database?

1051

What is partitioned table in Oracle?

1183

What is dynamic proxy?

1001

When do we use group by clause in a sql query?

1034

Why do we use bulk collect in oracle?

1058

Oracle

2371

What is an oracle data file?

1101

Explain an exception and its types?

1068

What is the difference between sharding and replication?

1034

Is oracle a programming language?

983

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2281

What do you mean by a database transaction & what all tcl statements are available in oracle?

989

What is the string concatenation operator in oracle?

1173