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 functions are used in sql?

0 Answers  

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

---

How to execute OS(operating system) command from pl/sql?

3 Answers  

---

how to install mysql? : Sql dba

0 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

What is informix sql?

0 Answers  

---

What is rownum in sql?

0 Answers  

---

scope of exception handling in plsql

4 Answers   Wipro,

---

How do I clear the screen in sql plus?

0 Answers  

---

How show all rows in sql?

0 Answers  

---

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

14 Answers   iGate, Wipro,

---