how to check the 3rd max salary from an employee table?
- 23 Answers
- 33844 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is the difference between the conventional and direct path loader? : aql loader
How to execute a stored procedure?
How do I run sql profiler?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is user defined functions?
What is sqlca in powerbuilder?
What are the different sql commands?
What has stored procedures in sql?
What is dba in sql? : SQL DBA
how do you control the max size of a heap table? : Sql dba
Can we have two clustered index on a table?
what are the drivers in mysql? : Sql dba
Can we use threading in pl/sql?
Can a view be mutating? If yes, then how?
What are the types of views in sql?
