Answer Posted / suren

hi Im SureRishi

SELECT *
FROM Employee E1
WHERE (4-1) = (
SELECT COUNT(DISTINCT(E2.Salary))
FROM Employee E2
WHERE E2.Salary > E1.Salary)

Which environment variables are absolutely critical in order to run the OUI?

2088

---

How to delete a user account in oracle?

931

---

What is oracle thin client?

990

---

How to get execution path reports on query statements?

949

---

How to unlock the sample user account in oracle?

960

---

What is a nested table and how is it different from a normal table?

1011

---

How to define and use table alias names in oracle?

902

---

How to run the anonymous block again?

1090

---

How to define an anonymous block?

1102

---

What to do if the binary spfile is wrong for the default instance?

1023

---

Whats the benefit of dbms_stats over analyze?

1964

---

Can group functions be used in the order by clause in oracle?

958

---

Explain rename?

945

---

What are the predefined tablespaces in a database?

1033

---

Does oracle charge for java?

1028

---