Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116011 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 I kill a query in postgresql?
What is database white box testing and black box testing?
How do I save a sql query?
What is sharding in sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What are all ddl commands?
What are literals in sql server?
What do you understand by case manipulation functions?
How many types of normalization are there?
How do you select unique values in sql?
Can we use pl sql in sql server?
What does varchar include?
Explain the steps needed to create the scheduled job?
How do you optimize a stored procedure query?
Explain clause in sql?
