Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116030 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 are the types of operators available in sql?
What is sqlerrm?
how to increment dates by 1 in mysql? : Sql dba
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What are schema-level triggers?
What are the query optimization techniques?
What are user defined functions?
What is a pdo connection?
Where not exists in sql?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
What is dcl in sql?
How do I partition in sql?
Explain the types of joins in sql?
Which is faster union or join?
Write a sql query to find the names of employees that begin with ‘a’?
