What are different types of joins ?

5 Answers   BirlaSoft,

---

Is inner join faster than left join?

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

---

What packages are available to pl/sql developers?

0 Answers  

---

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

---

What is a pragma statement?

0 Answers  

---

What is difference between mysql and postgresql?

0 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

What is union, minus and interact commands?

0 Answers  

---