how to check the 3rd max salary from an employee table?
- 23 Answers
- 32886 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / arjun
select min(sal) from (select sal from (select distinct(sal)
from emp order by sal desc) where rownum<4)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are triggers and its uses?
Can we have two clustered index on a table?
How do I run a pl sql procedure in sql developer?
How do you create a unique index?
What does pl sql developer do?
How do you bind variables in pl sql?
What is a constraint? Tell me about its various levels.
Is t sql a programming language?
What is mutating sql table?
How many commands are there in sql?
What is pl sql quora?
explain about mysql and its features. : Sql dba
What are the two types of exceptions.
Is sql a dbms?
what tools available for managing mysql server? : Sql dba
