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 to use null as conditions in oracle?

1003

---

What is the difference between sharding and partitioning?

931

---

What are oracle functions?

976

---

What are the differences between blob and clob in oracle?

1033

---

what are actual and formal parameters?

1051

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

978

---

What are ddl statements in oracle?

1018

---

How to import one table back from a dump file?

972

---

How can we force the database to use the user specified rollback segment?

1069

---

Name the three major set of files on disk that compose a database in Oracle?

1068

---

What are group functions in oracle?

975

---

What do you mean by merge in oracle?

939

---

Explain view?

980

---

What is analyze command used for?

1013

---

What is SQL Tuning Advisor in Oracle?

1109

---