need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

what is a table in a database ? : Sql dba

0 Answers  

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

Which is faster view or stored procedure?

0 Answers  

---

What are tables and fields?

0 Answers  

---

---

What are the sql aggregate functions?

0 Answers  

---

What is a sql profiler?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

What is the difference between execution of triggers and stored procedures?

0 Answers  

---

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

0 Answers  

---

What does sign mean sql?

0 Answers  

---

What is the purpose of the partition table?

0 Answers  

---