Answer Posted / santosh kumar

select employee_id,last_name,salary
from
(select rownum r,employee_id,last_name,salary
from (select employee_id,last_name,salary from employees
order by salary desc)) a
where a.r=&nth_salary;

---u can find nth highest salary----
for more detail u can contact me at
rajgupta7666@gmail.com....

what is the difference between where clause and having clause? : Sql dba

1047

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1086

---

How do I audit the sql sent to the server?

1059

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1015

---

Explain how to use transactions efficiently : transact sql

1017

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1684

---

What are the types of optimization?

1008

---

How do I view tables in sql developer?

1009

---

Is hadoop a nosql?

1054

---

What is sql not null constraint?

1096

---

What is the difference between rollback and rollback to statements?

1102

---

What are the two virtual tables available at the time of database trigger execution?

1273

---

Can we create view in stored procedure?

1026

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

---

Is primary key always clustered index?

1066

---