Answer Posted / nirad

select Top 1 *
from ( select top 3 * from Customer order by salary desc )
tempt
order by salary asc


if you want third lowest just desc with asc and asc with
desc and even if you want 2 or other hight value just
change inner query value of 3

Why does Oracle not permit the use of PCTUSED with indexes?

2421

---

What is the difference between formal parameters and actual parameters?

1081

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1985

---

6. Display the client name and order date for all orders using the traditional method.

2301

---

What are the different types of modules in oracle forms?

1001

---

Can we protect our pl/sql source code?

1042

---

What is the difference between a hot backup and a cold backup in oracle?

1013

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

---

How to export your own schema?

1007

---

How to create a testing table in oracle?

988

---

How to find out what oracle odbc drivers are installed?

1040

---

Explain joins in oracle?

1033

---

What is the oracle implicit cursor?

1058

---

What is backup in Oracle?

998

---

What is a partition in oracle?

1118

---