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
6633 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 is exception handling handled in mysql? : Sql dba

1007

Can we use ddl commands in pl sql?

1069

What is primary key secondary key alternate key candidate key?

980

How do I sort a table in sql?

983

How do you update sql?

913

What is graph sql?

936

how to present a past time in hours, minutes and seconds? : Sql dba

944

what are integrity rules?

964

What is %s in sql?

972

What is data types in sql?

950

What is cross join sql?

866

what is myisam? : Sql dba

1000

What if we write return in procedure?

1334

What company owns postgresql?

961

What is a temporal data type?

979