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

Give the various rollback segment states.

1055

---

Can you have more than one content canvas view attached with a window ?

2333

---

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

1369

---

List the various oracle database objects?

1061

---

What is using clause and give example?

1055

---

What is the difference between translate and replace in oracle?

1171

---

what is normalisation?what are its uses?

2278

---

How can we delete duplicate rows in a table?

979

---

How to calculate date and time differences in oracle?

1045

---

How to connect asp pages to oracle servers?

1075

---

What is the relation of a user account and a schema in oracle?

1083

---

Which is faster join or subquery in oracle?

998

---

How to rename an index?

1076

---

Can you assign multiple query result rows to a variable?

993

---

What is instant client oracle?

1028

---