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 / amit

Answer Posted / amit

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

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can you know that statistics should be updated?

1129

What are the datatypes available in pl/sql ?

1155

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1226

what is a trigger in mysql? Define different types of trigger. : Sql dba

1121

What is pl sql collection?

1017

What is cursor in pl sql?

1188

What is the maximum number of columns in sql table?

1231

Is and as keyword in pl sql?

1015

how to calculate expressions with sql statements? : Sql dba

1096

What are the different sql commands?

1130

How many commands are there in sql?

1091

What are character functions in sql?

996

Can one improve the performance of sql*loader? : aql loader

1099

What is trigger in sql and its types?

1113

What are the types of variable use in pl sql?

1138