Answer Posted / sreeharibabu

select * from (select emp.*,row_number() over(partition by deptno order by sal desc) rnk from emp) where rnk <=5 ;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO RNK
1 7839 X PRESIDENT 11/17/1981 5000.00 10 1
2 7782 X MANAGER 7839 6/9/1981 2450.00 10 2
3 7934 X CLERK 7782 1/23/1982 1300.00 10 3
4 700 X b 1234 9/9/2016 10:48:53 PM 1000.00 0.00 10 4
5 7369 X CLERK 7902 12/17/1980 8800.00 20 1
6 7788 X ANALYST 7566 4/19/1987 3000.00 20 2
7 7902 X ANALYST 7566 12/3/1981 3000.00 20 3
8 7566 X MANAGER 7839 4/2/1981 2975.00 20 4
9 7876 X CLERK 7788 5/23/1987 1100.00 20 5
10 7698 X MANAGER 7839 5/1/1981 2850.00 30 1
11 7499 X SALESMAN 7698 2/20/1981 1600.00 300.00 30 2
12 7844 X SALESMAN 7698 9/8/1981 1500.00 0.00 30 3
13 7521 X SALESMAN 7698 2/22/1981 1250.00 500.00 30 4
14 7654 X SALESMAN 7698 9/28/1981 1250.00 1400.00 30 5

What is recycle bin in Oracle?

1200

---

How to create a new oracle data file?

1077

---

What do you understand by database schema and what does it hold?

1302

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1135

---

How to establish administrator authentication to the server?

1099

---

List the various oracle database objects?

1112

---

How to update values on multiple rows in oracle?

1080

---

How to retrieve data from an explicit cursor?

1110

---

How to pass a cursor variable to a procedure?

1160

---

What to do if the binary spfile is wrong for the default instance?

1111

---

Is there a combination of "like" and "in" in sql?

1117

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2231

---

Is oracle an open source?

1128

---

What is a cursor in oracle?

1232

---

material view and view disadvantages?

1127

---