hi seenu, in this table have three coloumn thats are book,ver

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

Question Posted / arunarevathi.s

4 Answers
6980 Views
Adea, I also Faced
E-Mail Answers

Answer Posted / arunarevathi.s

hi seenu,
in this table have three coloumn thats are
book,version,numofbooks.
The query for u,
sql>select book,sum(numofbook)as count from book
group by book;

By,
aruna

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to use transactions efficiently : transact sql

1111

What are the steps for performance tuning.

1391

Is join same as left join?

1078

How delete all records from table in sql?

1010

explain the options of myisamchk to improve the performance of a table. : Sql dba

1072

How would you reference column values before and after you have inserted and deleted triggers?

1111

What is cte?

1019

how to convert numeric values to character strings? : Sql dba

1148

How can we debug in PL/SQL?

1171

What is sql injection vulnerability?

1002

What is offset in sql query?

1172

What are the different tcl commands in sql?

1224

What is query syntax?

1015

what is self-join? : Sql dba

1232

How to combine two stored procedures in sql?

1318