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
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
What is the difference between clustered and non-clustered indexes?
what is a database? : Sql dba
What operating systems are supported by oracle sql developer?
what are numeric data types? : Sql dba
Can we use view in stored procedure?
What is the difference between inner join and left join?
Explain commit, rollback and savepoint.
What is the purpose of my sql?
What is the difference between delete and truncate statement in sql?
What is having clause in sql?
What is exception? What are the types of exceptions?
Are stored procedures faster than queries?
Is there a way to automate sql execution from the command-line, batch job or shell script?
what is “go” in t-sql? : Transact sql
What is vector point function?