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 the difference between Delete, Truncate and Drop in Oracle?

1067

---

What is control file used for?

1102

---

How many categories of data types in oracle?

962

---

What is a trigger oracle?

1038

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2090

---

How can I combine multiple rows into a comma-delimited list in oracle?

1001

---

How to create a new table in your schema?

1034

---

What is the fastest query method to fetch data from the table?

1295

---

Explain a private synonyms?

983

---

What are the differences between number and binary_float in oracle?

1054

---

How do you store pictures in a database?

952

---

What's dateware house and what's clustor with practicle example

2127

---

does the query needs a hint to access a materialized view?

1817

---

What is a table index?

1013

---

Explain an integrity constrains?

1084

---