I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

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 primary key and unique key?

0 Answers  

---

Is and as keyword in pl sql?

0 Answers  

---

Does oracle roll back the transaction on an error?

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

What is a schema sql?

0 Answers  

---

How do I copy a table in sql?

0 Answers  

---

Is full outer join same as cross join?

0 Answers  

---

How to Declare Fixed Length String Value In PL SQL

0 Answers  

---

What are the different dcl commands in sql?

0 Answers  

---