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

How a tablespace is related to data files?

581

---

State and explain the different types of data models?

536

---

How to select all columns of all rows from a table in oracle?

588

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

550

---

What is the difference between sharding and replication?

475

---

---

In which language oracle has been developed?

645

---

How to select some columns from a table in oracle?

549

---

How to delete a user account in oracle?

551

---

How to create a new table by selecting rows from another table?

553

---

Why should I use oracle database?

569

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

651

---

What is the quickest way to fetch the data from a table?

568

---

What are the different types of partitions in oracle?

494

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1646

---

How can we find out the current date and time in oracle?

641

---