What is sorting in sql?

0 Answers  

---

Does truncate need commit?

0 Answers  

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

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,

---

how to do backup entire database? : Transact sql

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is scalar function in sql?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

What is sql scripting?

0 Answers  

---

How do you exit in sql?

0 Answers  

---

How sql query is executed?

0 Answers  

---

diff b/w function and procedure?

9 Answers   iFlex,

---