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
How do we accept inputs from user during runtime?
Is it possible to pass parameters to triggers?
What is gpt format?
how to create a table index in mysql? : Sql dba
what is try_catch block in procedure
What does := mean in pl sql?
Why we use join in sql?
Which is faster subquery or join?
define data blocks ? : Sql dba
What are different types of sql?
how many ways we can we find the current date using mysql? : Sql dba
how to create a new table by selecting rows from another table in mysql? : Sql dba
how to get a list of columns in an existing table? : Sql dba
What is secondary key?
Explain the difference between drop and truncate commands in sql?
