Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / santo
SELECT r.salary, r.department_id, r.RANK highest
FROM (SELECT salary, department_id,
DENSE_RANK () OVER (PARTITION BY
department_id ORDER BY salary DESC)
RANK
FROM employees) r
WHERE r.RANK <= 3
ORDER BY 2
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the operators in sql?
Explain the select statement in sql?
which types of join is used in sql widely? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is range partitioning?
Enlist the characteristics of pl/sql?
Explain two easy sql optimizations.
Write a query to display the current date in sql?
how to convert character strings to numeric values? : Sql dba
What is pragma in sql?
Can we have two clustered index on a table?
What is cursor in pl sql with examples?
What is the use of function "module procedure" in pl/sql?
Define union, minus, union all, intersect ?
What is a relationship and what are they?
