what is the difference between to_char and to_date functions?

10 Answers   Infosys,

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

Can we use distinct and group by together?

0 Answers  

---

How to pronounce postgresql?

0 Answers  

---

How to display Row Number with Records in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

Write a sql select query that only returns each name only once from a table?

0 Answers  

---

What are the Diff B/W Cursor and REF Cursor

3 Answers   CTS,

---

what is schema? : Sql dba

0 Answers  

---

What are triggers, and when would you use them?

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

---

Write the order of precedence for validation of a column in a table ?

2 Answers  

---