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

How to define and use table alias names in oracle?

987

What are the different types of failures that occur in Oracle database?

1116

What are privileges and grants?

1103

Explain the use of grant option in exp command.

1106

How to find the duplicate rows count from employees table in oracle?

1143

How to login to the server without an instance?

1213

Explain oracle left join with an example?

1058

What is meant by recursive hints in oracle?

1127

How to update values in a table in oracle?

1075

How to create lov dynamically at runtime & attach to text field?

1238

how to make an oracle object

2392

How to drop an existing view in oracle?

992

Explain table?

1174

How to pass parameters to procedures?

1085

How to define a variable of a specific record type?

1113