Can we use joins in subquery?

0 Answers  

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

What is primary and foreign key?

0 Answers  

---

Which is faster union or join?

0 Answers  

---

Explain the types of joins in sql?

0 Answers  

---

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,

---

Why is normalization important?

0 Answers  

---

How do you take the union of two tables in sql?

0 Answers  

---

Are left and right joins the same?

0 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

Why function is used in sql?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---