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,

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

cursor types? explain with example programs?

1 Answers   HP,

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

What are the types of join in sql?

0 Answers  

---

What is the purpose of using pl/sql?

0 Answers  

---

How to use transactions efficiently : transact sql

0 Answers  

---

What does closing a cursor do?

0 Answers  

---

What is difference between sql and mysql?

0 Answers  

---