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.

Can a key be both primary and foreign?

946

---

What is pl sql architecture?

924

---

What are the sql versions?

896

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1384

---

How many unique keys can a table have?

959

---

What is dialect in sql?

890

---

What is sql profiler in oracle?

1015

---

What is data abstraction in sql?

969

---

What is difference between nchar and nvarchar?

958

---

What is difference between sql and excel?

1010

---

Can ddl statements be used in pl/sql?

1070

---

what is row? : Sql dba

1168

---

What does closing a cursor do?

1247

---

what are the authentication modes in sql server? : Sql dba

1000

---

what is a constraint? Tell me about its various levels. : Sql dba

932

---