Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118094 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
Is primary key clustered or nonclustered?
What is sql deadlock?
What is sql entity?
What are the 3 types of behavioral triggers?
What is rollback?
What is lexical units in pl sql?
how to include numeric values in sql statements? : Sql dba
how mysql optimizes distinct? : Sql dba
What is a left inner join?
Does inner join return duplicate rows?
What is sap sql anywhere?
Is join an inner join?
what are null values? : Sql dba
Explain scalar functions in sql?
How do I run a pl sql procedure in sql developer?
