Answer Posted / krish

how to fine top 3 emp(sal) from each deptno
i want the out put like this
sal deptno
100 20
200 20
300 20
150 30
250 30
350 30
so top 3 from each dept
thank u

What are the different sql languages?

1042

---

What does pl sql developer do?

936

---

Why do we use view in sql?

970

---

is mysql query is case sensitive? : Sql dba

1107

---

Determine if oracle date is on a weekend?

1042

---

What do you think about pl/sql?

1041

---

What does rownum mean in sql?

1034

---

how to convert dates to character strings? : Sql dba

1178

---

How do I find duplicates in a single column in sql?

1025

---

How does postgresql compare to mysql?

1039

---

how to use like conditions? : Sql dba

1115

---

List the various privileges that a user can grant to another user?

1047

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

986

---

how to create a new view in mysql? : Sql dba

943

---

What is difference between pls_integer and integer?

969

---