Interested to Buy Any Domain ? << Click Here >> for more details...
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 many aggregate functions are available there in sql?
What is the primary use of normalization?
Define tables and fields in a database
What is the requirement of self-join?
How do you declare a constant?
What is union and union all keyword in sql?
What is the use of & in pl sql?
how to get help information from the server? : Sql dba
How to order siblings in oracle hierarchy queries?
What is the advantage of index in sql?
Where is pl sql used?
What is pl sql in dbms?
What is rtm stands for?
What is varchar data type in sql?
What is trigger explain it?
