Answer Posted / selvaraj v

In oracle 10g :

SELECT * FROM
(SELECT DEPTNO,
EMPNO,
ENAME,
SAL,
DENSE_RANK() OVER(PARTITION BY DEPTNO ORDER BY SAL
DESC) RANK
FROM EMP);

OUTPUT :
------------>

DEPTNO EMPNO ENAME SAL RANK
---------- ---------- ---------- ---------- ----------
10 7839 KING 5000 1
10 7782 CLARK 2450 2
10 7934 MILLER 1300 3
20 7788 SCOTT 3000 1
20 7902 FORD 3000 1
20 7566 JONES 2975 2
20 7876 ADAMS 1100 3
20 7369 SMITH 800 4
30 7698 BLAKE 2850 1
30 7499 ALLEN 1600 2
30 7844 TURNER 1500 3

DEPTNO EMPNO ENAME SAL RANK
---------- ---------- ---------- ---------- ----------
30 7521 WARD 1250 4
30 7521 WARD 1250 4
30 7654 MARTIN 1250 4
30 7900 JAMES 950 5

15 rows selected.

Explain the dml?

952

---

How to create a new view in oracle?

1056

---

How can I get column names from a table in oracle?

1031

---

What are the different pseudo commands? Explain in general?

1055

---

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

1061

---

How to delete a column in an existing table in oracle?

1047

---

How to unlock the sample user account in oracle?

990

---

What happens to indexes if you drop a table?

1155

---

How to use "out" parameter properly?

1069

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4499

---

How to recover a dropped table in oracle?

1021

---

What is not equal to in oracle?

980

---

How to create a table index in oracle?

1112

---

How do I manually uninstall oracle client?

1066

---

What is columnar storage what is the advantage?

1032

---