Answer Posted / shailesh j
SELECT * FROM (
SELECT DEPARTMENT_ID,SALARY,DENSE_RANK() OVER(PARTITION BY
DEPARTMENT_ID ORDER BY SALARY DESC) AS RK FROM EMPLOYEES)
WHERE RK<4;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a behavioral trigger?
How delete all records from table in sql?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
How many databases can sql express handle?
How to fix oracle error ora-00942: table or view does not exist
Mention what problem one might face while writing log information to a data-base table in pl/sql?
Why do we use %rowtype & %type in plsql?
Which is better join or inner query?
what is single byte over head in oracle..?
What is execute immediate?
is mysql query is case sensitive? : Sql dba
What is rowtype?
What is pl sql quora?
Why should I use postgresql?
Can we create table inside stored procedure?