select substring(trade,1,(len(trade)-3)) as trade,sum(no

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 / suman maan

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

Answer Posted / suman maan

select substring(trade,1,(len(trade)-3)) as
trade,sum(no_ofbooks)
from test
group by substring(trade,1,(len(trade)-3))

Trade is bookname like(java1.1,.Net305)
no_ofbooks as indivisual book count

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how do you login to mysql using unix shell? : Sql dba

1130

Is drop table faster than truncate?

1051

What is a join query?

1007

what is a trigger in mysql? Define different types of trigger. : Sql dba

1121

can sql servers linked to other servers like oracle? : Sql dba

1054

Can we use joins in subquery?

1230

What is pragma in sql?

1128

What is difference between pls_integer and integer?

1011

what is uncommittable transactions? : Transact sql

1038

what is timestamp in mysql? : Sql dba

1133

Is sql between inclusive?

1199

What is sql and its types?

1254

Do foreign keys improve performance?

1068

What is asqueryable?

1037

Can we use insert statement in function?

1048