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 does := mean in pl sql?

1052

---

How global cursor can be declare with dynamic trigger ?

2215

---

What are the advantages of pl sql?

1127

---

What is a dirty read sql?

1164

---

How many disk partitions should I have?

995

---

What is procedure and function in sql?

1003

---

How does rowid help in running a query faster?

1424

---

Which are the different character-manipulation functions in sql?

1075

---

What is a procedure in pl sql?

1216

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

2270

---

What is coalesce in sql?

1069

---

describe mysql connection using mysql binary. : Sql dba

1074

---

Can ddl statements be used in pl/sql?

1152

---

How to revise and re-run the last sql command?

1172

---

What are the types of functions in sql?

1027

---