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
6676 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 many clustered indexes can you have?

935

Does truncate free space?

957

How do you declare a variable in pl sql?

982

Can we insert data into materialized view?

904

Can variables be used in sql statements?

991

Can a foreign key be null?

1038

what is the difference between blob and text? : Sql dba

975

What is dialect in sql?

897

how do you tune the slow running queries in oracle db , explain the methodology

2212

how can we know the count/number of elements of an array? : Sql dba

1022

How do I install sql?

950

what is collation? : Sql dba

1093

How many primary keys can a table have?

967

What is an emotional trigger?

947

How can I change database name in sql?

1021