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

how to check the 3rd max salary from an employee table?

Question Posted / srinivas

Answer Posted / srinivas

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 download oracle sql developer?

1110

Which one is better subquery or joins?

1062

What is a pragma statement?

1262

What is acid property in a database?

1035

What is the reports view in oracle sql developer?

994

Why coalesce is used in sql?

1012

What is the use of <> sql?

980

Is sql open source?

979

how to use myisamchk to check or repair myisam tables? : Sql dba

972

Can we group by two columns in sql?

996

What is varray in pl sql?

1075

What does the argument [or replace] do?

1082

Explain what is a database?

1087

Does varchar need length?

994

what is a database? : Sql dba

1173