how to check the 3rd max salary from an employee table?
- 23 Answers
- 32894 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kumar sumit
select max(sal) from emp where sal not in(select max(sal)
from emp where sal not in(select max(sal) from emp))
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is a mutating table and a constraining table?
What do you mean by stored procedures? How do we use it?
Write the command to remove all players named sachin from the players table.
how to rename an existing table in mysql? : Sql dba
Explain what is sql*plus?
What are the query optimization techniques?
What are the two parts of design view?
What is the difference between the conventional and direct path loads? : aql loader
What is cursor in pl sql?
Can a foreign key be a duplicate?
how to fetch common records from two tables? : Sql dba
what are tables and fields? : Sql dba
Why do we need cursors in pl sql?
How much does sqlite cost?
How does join work in sql?
