Answer / manish_patil

select sal from emp_sal where rownum = 3 order by sal desc

Answer / tushar

select max(sal) from ( select sal from emp group by sal order by sal) where rownum<4;

Answer / nagendra

select min(sal) from emp where sal in( select top 3 sal
from emp order by sal desc)

Why cross join is used?

0 Answers  

---

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

0 Answers  

---

can i give user defined exception in a package

2 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

---

Which language is used in sql?

0 Answers  

---

What is a memo field?

0 Answers  

---

What is a database event trigger?

0 Answers  

---

What is the differnce between view and materialized view

4 Answers   TCS,

---

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

---

What is the Subquery?

4 Answers  

---