Can we use distinct and group by together?

0 Answers  

---

How do we tune the code?

2 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

---

what is clause? : Sql dba

0 Answers  

---

What is pl sql package?

0 Answers  

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

What is sql query limit?

0 Answers  

---

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

0 Answers  

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---