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.

What is online transaction processing (oltp)?

1058

---

What is nosql example?

1089

---

What are different types of indexes?

1053

---

What is benefit of creating memory optimized table?

1031

---

How do I find duplicates in the same column?

1169

---

What is the difference between view and stored procedure?

999

---

How do you update a value in sql?

1100

---

What are the uses of sysdate and user keywords?

1148

---

How to use transactions efficiently : transact sql

1114

---

Is sql a oracle?

1022

---

How much does a sql dba make? : SQL DBA

986

---

Is time a data type in sql?

960

---

What is a heap in sql?

1137

---

What is data type in database?

1039

---

What is bind variable in pl sql?

1102

---