Answer Posted / asit kumar sahu

SELECT DISTINCT SAL FROM EMP E1
WHERE 2=(SELECT COUNT(DISTINCT SAL) FROM EMP E2
WHERE E1.SAL <= E2.SAL);

OUTPUT= 3000

query optmization techniques and quwry analyser+projects+ppts

1931

---

Explain how are indexes update?

622

---

Write a trigger example in oracle?

573

---

How is it different from a normal table?

582

---

How to display row numbers with the records?

588

---

---

What privilege is needed for a user to connect to oracle server?

555

---

What is logical backup in oracle?

578

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1731

---

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1785

---

How to rename an existing table?

607

---

Explain the use of show option in imp command.

638

---

What is a dead lock in oracle?

596

---

How to see free space of each tablespace?

595

---

What is a snapshot log?

564

---

Give syntax for SQL and ORACLE joins.

634

---