Answer Posted / noorulahaq

select min(sal) from emp where sal in (
select sal from
( select sal from emp order by sal desc )
where rownum <=3 )

What is the difference between drop and truncate commands?

1110

---

What is rollback?

1184

---

how to fetch alternate records from a table? : Sql dba

1166

---

What does the argument [or replace] do?

1127

---

What does where 1 1 mean in sql?

1077

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1134

---

Can two tables have same primary key?

1024

---

How do I find sql profiler?

992

---

How to start the command-line sql*plus?

1109

---

what are rollup and cube in t-sql? : Transact sql

1149

---

what is acid property in database? : Sql dba

1069

---

What are the various levels of constraints?

1167

---

Can you inner join the same table?

1039

---

Give the order of sql select?

1185

---

What are sql built in functions?

981

---