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 is pl/sql language case sensitive?
What is cursor status?
How can I tell if sql is running?
What is a memo field?
How do you optimize a query?
How do you use collections in procedure to return the resultset?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Why use stored procedures?
How do you modify a table in sql?
Which is faster subquery or join?
How can you get sql*loader to commit only at the end of the load file? : aql loader
Explain commit, rollback and savepoint.
Why function is used in sql?
What does partition by mean in sql?
How much ram can sql express use?
