Write a query to find second highest salary of an employee.
- 27 Answers
- 21976 Views
- I also Faced
- E-Mail Answers
Answer Posted / oboyah
SELECT e1.* from ( SELECT last_name, salary,
DENSE_RANK() OVER ( ORDER BY salary DESC) rank
FROM employees) e1 where e1.Rank = 2;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of design view?
What operators deal with null?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is the order of sql select?
How can we optimize a sql query?
What are the differences between implicit and explicit cursors?
what are different types of keys in sql?
What is scope and visibility in PL/SQL?
How do you take the union of two tables in sql?
Are stored procedures compiled?
What is the difference between a primary key and a clustered index?
What is the sql*loader? : aql loader
What does the argument [or replace] do?
When do we use triggers?
what are different types of collation sensitivity? : Sql dba
