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 data type in database?

951

---

How many sectors are in a partition?

1049

---

What are properties of the transaction?

972

---

what is a field in a database ? : Sql dba

1020

---

what is innodb? : Sql dba

1058

---

How do I edit a trigger in sql developer?

952

---

What is sql prepared statement?

955

---

Can you inner join the same table?

956

---

how are mysql timestamps seen to a user? : Sql dba

1084

---

What program will open a mdb file?

936

---

how to escape special characters in sql statements? : Sql dba

998

---

Can we use two order by clause in query?

937

---

What are the benefits of stored procedures?

1021

---

How to add new employee details in an employee_details table with the following details

1058

---

What are character functions in sql?

908

---