How can we make an if statement within a select statement?

0 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 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,

---

What is delete command in sql?

0 Answers  

---

What is synonyms?

0 Answers  

---

Differentiate between % rowtype and type record.

0 Answers  

---

Which normal form is best?

0 Answers  

---

What are the advantages of VIEW?

5 Answers  

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

Can you have more than one trigger on a table?

0 Answers  

---

What is the difference between count 1 and count (*) in a sql query?

0 Answers  

---

How does a covering index work?

0 Answers  

---