select max(sal) from emp where sal < (select max(sal) from emp where sa

find out the third highest salary?

Question Posted / harikrishna ravipati

Answer Posted / harikrishna ravipati

select max(sal) from emp where sal <
(select max(sal) from emp where sal <
(select max(sal) from emp))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dynamic proxy?

1003

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865

How different is ms access and oracle?

1036

How can I introduce multiple conditions in like operator?

984

Can you drop an index associated with a unique or primary key constraint?

1019

What is a parameter file in oracle?

1133

What do you mean by redo log file mirroring?

1026

What is the sql query to concatenate column values from multiple rows in oracle?

1054

What is proxy method?

971

Give the advantages and disadvantages of clusters.

1050

How to write date and time literals in oracle?

1002

How does Oracle guarantee data integrity of data changes?

2386

What is merge statement used for?

1024

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353

State some uses of redo log files?

1001