Answer Posted / amit sutar

select min(salary)

from(select distinct(salary)
from employees
order by salary desc)

where rownum<=5;

How to create an initialization parameter file?

1101

---

What is the difference between postgresql and oracle?

1101

---

What is rowid and rownum in oracle?

1064

---

Can a formula column referred to columns in higher group ?

2550

---

What is catalog in Oracle?

1431

---

Which environment variables are absolutely critical in order to run the OUI?

2170

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1048

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5673

---

What are the different types of synonyms?

1197

---

Is postgres faster than oracle?

1080

---

How to upsert (update or insert into a table)?

1042

---

What is bulk collect in oracle?

1052

---

How do you store pictures in a database?

1057

---

How to get a list of all user accounts in the database?

1129

---

Hi Can any one tell me what are the API's used in requisition import.

1964

---