try this select max(salary) from employees where salary

find out the third highest salary?

Question Posted / gaurav

Answer Posted / gaurav

try this

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create a table index in oracle?

1132

Explain the use of tables option in exp command.

1115

Explain the use of owner option in exp command.

1041

How to retrieve the count of updated rows?

1126

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2355

Is postgres faster than oracle?

1031

What is a schema in oracle?

1012

What is the usage of save points in oracle database?

964

What is sequence?

1078

What is the dynamic sql in oracle?

1071

What is the sid in oracle?

963

Explain an exception and its types?

1073

What are the ansi data types supported in oracle?

946

How remove data files before opening a database?

1068

In the oracle version 9.3.0.5.0, what does each number shows?

1297