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 get help information from the server? : Sql dba

949

---

What is rowtype?

1028

---

What is bulk collect in pl sql?

1102

---

What is rollback?

1119

---

Explain what is a view?

1067

---

What is the difference between delete and truncate commands?

1050

---

Can 2 queries be executed simultaneously in a distributed database system?

1155

---

What are the types of join and explain each?

1059

---

What does trigger mean in psychology?

971

---

Is sql workbench free?

1008

---

what is not null constraint? : Sql dba

1042

---

Does group by remove duplicates?

1048

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1064

---

What does count (*) mean?

937

---

How to create a menu in sqlplus or pl/sql?

1131

---