Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120072 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / debasish sinha
select ename,sal,deptno
from emp
where sal =
(
select max(sal)
from emp
where level=2
connect by prior sal>sal
group by level
)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is pl sql variable?
What are different functions in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is a mutating table and a constraining table?
What does sql stand for?
What is anonymous block in sql?
Is ms sql is free?
What are the types of subqueries?
What are the steps for performance tuning.
What is a dirty read sql?
Who developed sql?
Explain raise_application_error.
How many types of literals are available in pl sql?
What is trigger and stored procedure in sql?
What is dynamic query?
