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

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2602

---

Calculate difference between 2 date / times in oracle sql?

1099

---

How to experiment a data lock in oracle?

1112

---

Is there an oracle sql query that aggregates multiple rows into one row?

1032

---

Difference between varchar and varchar2 data types?

1262

---

Why packages are used in oracle?

1119

---

Explain about functional dependency and its relation with table design?

1061

---

How to empty your oracle recycle bin?

1077

---

What is the sql query to concatenate column values from multiple rows in oracle?

1106

---

How to check database size in Oracle?

1257

---

How to fetch the row which has the max value for a column?

1046

---

What are the attributes that are found in a cursor?

1122

---

What is an oracle wallet?

993

---

What is the relation of a user account and a schema?

1176

---

What would you do with an in-doubt distributed transaction?

2049

---