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 is the difference between clustered and non-clustered indexes?

605

---

Are left and right joins the same?

536

---

What is the difference between microsoft access and sql server?

533

---

How do I add a primary key to a table?

545

---

What is rename command in sql?

469

---

---

What is the most restrictive isolation level? : Transact sql

563

---

Is natural join and inner join same?

502

---

Is sql injection illegal?

597

---

How can you load multi line records? : aql loader

663

---

What is cursor explain with example?

560

---

Why we use joins in sql?

544

---

What is difference between sql function and stored procedure?

508

---

how to shut down the server with 'mysqladmin'? : Sql dba

549

---

What types of commands can be executed in sql*plus?

554

---

Does inner join remove duplicates?

524

---