Answer Posted / av.anil

SELECT * FROM
(SELECT Ename,Sal,
DENSE_RANK()
OVER(ORDER BY Sal DESC) "D_RK"
FROM Emp)
WHERE D_RK = 3;

This query gives exact highest salary.

How to display the current date in sql?

1058

---

What is the maximum database size for sql express?

1011

---

Enlist some predefined exceptions?

1041

---

What is rename in sql?

958

---

What are inner outer left and right joins in sql?

1002

---

How to handle bulk data?

1300

---

What do you know by pl/sql cursors?

1093

---

What are the types of join in sql?

1084

---

Which is faster union or join?

951

---

Why trigger is used in sql?

953

---

Does sql*plus have a pl/sql engine?

1055

---

How can you load microsoft excel data into oracle? : aql loader

1157

---

What is the need of merge statement?

1014

---

Why do we use view in sql?

935

---

Which one is faster ienumerable or iqueryable?

923

---