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,

---

How can I delete duplicate rows?

0 Answers  

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---

Why is sql*loader direct path so fast?

0 Answers  

---

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

---

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

---

Explain the working of foreign key?

0 Answers  

---

How do temporal tables work?

0 Answers  

---

What is difference between hql and sql?

0 Answers  

---

define primary key & secondary key?

2 Answers  

---

What is bind variable in pl sql?

0 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---