Answer Posted / divakarreddy
SQL> select *from (select ename,sal,deptno,rank()
2 over(partition by deptno order by sal desc)topsal
3 from emp)
4 where topsal<=3
5 order by deptno,sal desc;
ENAME SAL DEPTNO TOPSAL
---------- ---------- ---------- ----------
KING 5000 10 1
MILLER 3000 10 2
CLARK 2450 10 3
SCOTT 3000 20 1
JONES 2975 20 2
ADAMS 1100 20 3
BLAKE 2850 30 1
ALLEN 1600 30 2
TURNER 1500 30 3
9 rows selected.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is use pl and sql?
What is the primary key?
Is sql between inclusive?
What is trigger and types?
What is varray in pl sql?
What is the difference between having and a where in sql?
Is a foreign key always unique?
What are keys in sql?
How many types of cursors are available in pl/sql?
How many functions are there in sql?
Which is faster truncate or drop?
Is t sql a programming language?
Explain the significance of the & and && operators in pl sql.
what is row? : Sql dba
What is mutating error?