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 a pdo connection?

1120

---

What are the sql commands?

1232

---

What is the purpose of using pl/sql?

1189

---

Is left join faster than join?

1096

---

Which command is used to call a stored procedure?

1055

---

what are all the different normalizations? : Sql dba

1123

---

Where can I learn sql for free?

1050

---

how to enter numeric values as hex numbers? : Sql dba

1104

---

Is sql low level language?

1067

---

How to take user input in pl sql?

1207

---

What is a trigger word?

1081

---

What does pl sql developer do?

982

---

How do you exit in sql?

1160

---

what is data integrity? : Sql dba

1086

---

Why use subqueries instead of joins?

1138

---