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 are database links used for?
What is orm in sql?
Who is the owner of mysql database?
What is sql*loader and what is it used for? : aql loader
Is id a reserved word in sql?
what are the different index configurations a table can have? : Sql dba
what are all the different normalizations? : Sql dba
How can we make an if statement within a select statement?
What are % type and % rowtype?
What are aggregate functions in sql?
How do I pipe the output of one isql to another?
Inline the values in PL/SQL, what does it mean.?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
how to include character strings in sql statements? : Sql dba
What is the difference between delete and truncate statement in sql?
