What is rank dense_rank and partition in sql?

0 Answers  

---

What is equi join in sql?

0 Answers  

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

Talk about views

10 Answers   Polaris,

---

---

what are the different functions in sorting an array? : Sql dba

0 Answers  

---

What is right join sql?

0 Answers  

---

What is scalar and vector?

0 Answers  

---

What are the query optimization techniques?

0 Answers  

---

What is dbo in sql?

0 Answers  

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

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,

---