Answer / xxx

select ename, salary from
(Select ename, salary, rownum
FROM emp where rownum<=3
Order by salary )
where rownum = 1
;

How is sql used in oracle?

0 Answers  

---

Why do we use %rowtype & %type in plsql?

0 Answers  

---

What is the difference between truncate and drop statements?

0 Answers  

---

what is global variable in package

3 Answers   Polaris,

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

---

How do you explain an index?

0 Answers  

---

What are types of joins?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

What is Difference between StoredProcedure and function?

3 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

What is integrity in sql?

0 Answers  

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

4 Answers   Satyam,

---