how to check the 3rd max salary from an employee table?
Answer Posted / tushar
select max(sal) from ( select sal from emp group by sal order by sal) where rownum<4;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How can I change database name in sql?
Why do we use sqlite?
What is hibernate and its relation to sql?
What are the types of join in sql?
Define commit, rollback and savepoint?
What is coalesce sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What do you mean by stored procedures? How do we use it?
Can you have more than one key in a database?
What are triggers and its types?
How do I partition in sql?
How does cross join work in sql?
Differentiate between pl/sql and sql?
What is the difference between function and procedure in pl/sql?
What is data modelling in sql?