Why having clause is used in sql?

0 Answers  

---

What is substitution variable?

0 Answers  

---

what is self join and how it works??

2 Answers   Infosys,

---

How to run sql commands in sql*plus?

0 Answers  

---

How do you modify a column in sql?

0 Answers  

---

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---

How do you optimize a stored procedure in sql?

0 Answers  

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

What is sql partition?

0 Answers  

---

What is package in pl sql?

0 Answers  

---