Answer Posted / divakarreddy

SQL> select *from (select ename,sal,deptno,rank()
2 over(partition by deptno order by sal desc)topsal
3 from emp)
4 where topsal<=3
5 order by deptno,sal desc;

ENAME SAL DEPTNO TOPSAL
---------- ---------- ---------- ----------
KING 5000 10 1
MILLER 3000 10 2
CLARK 2450 10 3
SCOTT 3000 20 1
JONES 2975 20 2
ADAMS 1100 20 3
BLAKE 2850 30 1
ALLEN 1600 30 2
TURNER 1500 30 3

9 rows selected.

How can we solve sql error: ora-00904: invalid identifier?

1247

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1064

---

Is sql harder than python?

1108

---

What is the most common sql injection tool?

1042

---

What is break?

1198

---

What is rowtype?

1021

---

What is the difference between left and left outer join?

945

---

What are database links used for?

1048

---

Does sqlite need a server?

1053

---

What is an oracle stored procedure?

1053

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2150

---

What do you mean by table in sql?

991

---

what is heap table? : Sql dba

1106

---

Can we use view in stored procedure?

902

---

How do I edit a trigger in sql developer?

995

---