Answer Posted / haneef

Best One

select top 1 * from test_emp where sal in (select top 3 sal
from test_emp order by sal desc) order by sal asc

or

It also work

select top 1 * from test_emp where sal in (select top 3 sal
from test_emp order by sal desc) order by sal asc
select top 1 MAX(sal),id from test_emp where sal < (select
max(sal) from test_emp where sal < (select max(sal) from
test_emp))
group by id,sal order by sal desc

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

2120

---

Why do we use bulk collect in oracle?

1058

---

What are the differences between number and binary_float in oracle?

1100

---

What happens to the current transaction if the session is killed?

989

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2149

---

How to rename an existing table?

1129

---

What are the general rules on data consistency?

1009

---

Is there any function in oracle similar like group_concat of mysql?

1053

---

How to delete an existing row from a table in oracle?

1072

---

What is private procedure oracle?

1012

---

How to assign values to data fields in record variables?

1035

---

What to do if the startbd.bat failed to start the xe instance?

1083

---

Is rowid unique in oracle?

998

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

---

What is rowid and rownum in oracle?

1011

---