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 do I pipe the output of one isql to another?

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

What is on delete restrict?

0 Answers  

---

how to see the create table statement of an existing table? : Sql dba

0 Answers  

---

---

Define implicit and explicit cursors.

0 Answers  

---

Define tables and fields in a database

0 Answers  

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

Compare sql & pl/sql

0 Answers  

---

Why indexing is needed?

0 Answers  

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---