Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120103 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
what are the limitations of identity column? : Transact sql
Why we use sql profiler?
Can sql function call stored procedure?
What is difference between inner join and cross join?
what is commit? : Sql dba
what are the non-standard sql commands supported by 'mysql'? : Sql dba
How do you go back in sql?
how to get help information from the server? : Sql dba
explain the delete statements in sql
How subquery works in sql?
Is like operator in sql case sensitive?
what is “go” in t-sql? : Transact sql
What are literals in sql server?
What are the query optimization techniques?
What is gpt format?
