Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118578 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 a string data type in sql?
What are synonyms in sql?
What does data normalization mean?
Explain the difference between triggers and constraints?
What is a function in oracle pl sql?
How to execute a stored procedure?
Why do we use procedures in sql?
Which is better varchar or nvarchar?
What problem one might face while writing log information to a data-base table in pl/sql?
What is consistency?
what are the advantages a stored procedure? : Sql dba
What do you mean by dbms? What are its different types?
What is an ndf file?
What does seeding a database mean?
how to calculate the difference between two dates? : Sql dba
