Answer Posted / abhijit ramakant parb

select min(a.sal) from(select distinct d.sal from emp d
order by sal desc) a where rownum<=2;

To retrieve all columns

select * from emp where sal=(select min(a.sal) from(select
distinct d.sal from emp d order by sal desc) a where
rownum<=2);

What are data pump export and import modes?

1014

---

How to connect the oracle server as sysdba?

1009

---

Explain database link?

1059

---

What are the limitations oracle database 10g xe?

975

---

What are the different types of modules in oracle forms?

951

---

How to manage transaction isolation level?

948

---

What is private procedure oracle?

953

---

When system tablespace is created?

967

---

How to invoke the data pump export utility?

1114

---

Explain the use of online redo log files in oracle.

991

---

what is the difference between substr and instr function in oracle?

1033

---

What is the simplest tool to run commands on oracle servers?

954

---

What is a proxy class?

967

---

What is the difference between sharding and partitioning?

928

---

what are steps for interface? where is exchange rate defined in which table?

2054

---