Answer Posted / chiru
select *
from (select row_number() over(partition by deptno order by sal desc) r,
b.*
from (select rownum num, a.* from emp a order by sal desc) b)
where r <= 3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you take the union of two tables in sql?
What is oracle sql developer?
Is sql a microsoft product?
What is the difference between execution of triggers and stored procedures?
What are the packages in pl sql?
Can ddl statements be used in pl/sql?
Does truncate free space?
what is column? : Sql dba
What is the difference between rollback and rollback to statements?
What are the benefits of pl sql?
What are different joins used in sql?
What is sql injection owasp?
How delete all data from table in sql?
Write a query to find the names of users that begin with "um" in sql?
What is sql partition function?