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.

How can a pl sql block be executed?

893

---

How you improve the performance of sql*loader? : aql loader

957

---

What is the purpose of the partition table?

1005

---

Is sql easier than java?

947

---

How to start oracle sql developer?

986

---

What are the built in functions of sql?

983

---

What is the difference between distinct and unique in sql?

878

---

how to create a new table in mysql? : Sql dba

936

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

957

---

What is the maximum number of rows in sql table?

957

---

How many clustered indexes can be created on a table?

1026

---

Does truncate release storage space?

1018

---

Is and as keyword in pl sql?

908

---

Write the alter statement to enable all the triggers on the t.students table.

1070

---

Does sql full backup truncate logs?

969

---