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 suggestions do you have to reduce the network traffic?

901

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1591

How to define an oracle cursor variable?

977

Explain the blob datatype?

1016

ABOUT IDENTITY?

2006

How to use "for" statements in oracle?

1019

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2046

What is ceil and floor in oracle?

1011

How to get execution statistics reports on query statements?

1009

What is the use of oracle?

984

How to invoke the data pump export utility?

1117

What is the difference between a hot backup and a cold backup in oracle?

961

How to create a new table in oracle?

1067

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2291

How to assign a tablespace to a users in oracle?

992