Answer Posted / venkateswara thiruvedhula

SELECT empno,
deptno,
sal,
RANK() OVER (PARTITION BY deptno ORDER BY sal
desc) "rank"
FROM emp;

EMPNO DEPTNO SAL rank
---------- ---------- ---------- ----------
7934 10 5000 1
7782 10 3000 2
7839 10 2000 3
7369 20 2950 1
7876 20 1700 2
7566 20 1100 3
7788 20 900 4
7902 20 900 4

What is latest version of sql?

1103

---

What is orm in sql?

1099

---

What is multiple columns?

1120

---

Can you rollback after commit?

1054

---

What is varchar data type in sql?

1140

---

Which sql most popular?

1031

---

What is sql*plus?

1122

---

What is the use of prepared statement?

1077

---

Can a table have no primary key?

1113

---

What is view explain with example?

1001

---

What is procedure and function in sql?

1047

---

How do you define a foreign key?

1067

---

Why we use pl sql?

1009

---

How can I speed up sql query?

1008

---

Explain the advantages and disadvantages of stored procedure?

1200

---