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

How many types of tables are there in oracle?

1112

---

How to create an initialization parameter file?

1106

---

What is different types of joins?

1080

---

What is recovery manager(rman) backup in Oracle?

1232

---

How to create an oracle testing table?

1128

---

How to rename an existing table?

1219

---

How to assign query results to variables?

1098

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2362

---

Explain integrity constraint?

1209

---

What is a static data dictionary in oracle?

1192

---

How to drop an existing view in oracle?

992

---

How to get the Installed Oracle Version Information ?

1191

---

> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

2093

---

Can we connect to ORACLE db using Windows Authentication?

1308

---

How to create a new table by selecting rows from another table?

1151

---