Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118101 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
How do you change a value in sql?
What is the most important ddl statements in sql are?
What is coalesce sql?
what is a control file ? : Sql dba
What view means?
how to escape special characters in sql statements? : Sql dba
Where is pl sql used?
Explain locks? : Transact sql
How do you delete a table?
How to revise and re-run the last sql command?
What is the difference between alter trigger and drop trigger statements?
What are the benefits of pl sql?
How to write a query to show the details of a student from students table whose
Can we connect to postgresql using sql developer?
Is sql free?
