Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118737 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / mark berlin.
REM solution #1:
select * from(
select distinct nvl(salary,-1) as sal
from employees
where nvl(salary,-1) < (select max(nvl(salary,-1)) from
employees)
order by nvl(salary,-1) desc)
where rownum=1;
REM Solution #2
select * from (
select distinct salary from employees
order by salary
desc
)
where rownum < 3
minus
select * from (
select distinct salary from employees
order by salary
desc
)
where rownum =1;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is out parameter used for eventhough return statement can also be used in pl/sql?
What are actual parameters and formal parameters?
What is dialect in sql?
What does joining a thread mean?
Is sql a backend language?
Write a sql select query that only returns each name only once from a table?
What is dynamic sql in pl sql?
What is data manipulation language?
How do you define a foreign key?
Is sql port 1433 encrypted?
What packages are available to pl/sql developers?
what is sub-query? : Transact sql
What is the benefit of foreign key?
What is flag in sql?
How is data stored in sql?
