how to check the 3rd max salary from an employee table?
- 23 Answers
- 33798 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / gourvendra singh
In oracle you can find the 3rd max salary with the help of
the command:-
select sal from(select sal from(select distinct sal from
emp order by sal desc)
where rownum <=3 order by sal asc) where rownum=1;
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What is the difference between an inner join and an outer join?
What are the features of pl sql?
How to run sql*plus commands in sql developer?
Can we use distinct and group by together?
what is an alias command? : Sql dba
What is a parameter query?
What is sql*loader and what is it used for?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Are sql connections encrypted?
Explain polymorphism in pl/sql.
What is difference between sql and mysql?
Why we use sql profiler?
what are all the different types of indexes? : Sql dba
What is dba in sql? : SQL DBA
Explain clause in sql?
