Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102900 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
-- Solution #3
select distinct salary from (
select salary,
RANK() OVER (order by salary desc NUlls last) as RRANK
FROM employees
)
Where RRANK = 2;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why commit is not used in triggers?
What is the maximum rows in csv?
Which certification is best for sql?
What is sql trigger example?
What is java sql package?
What are pl/sql cursor exceptions?
What are the different types of triggers?
What is the difference between delete, truncate and drop command?
What is a database? Explain
when is the use of update_statistics command? : Sql dba
what are null values? : Sql dba
what is normalization? : Sql dba
what is a trigger in mysql? : Sql dba
What is constant in pl sql?
what are the advantages of using stored procedures? : Sql dba
