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
- 4 Answers
- 5448 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
What is procedure and function in sql?
Can we create index on primary key?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
what is the difference between join and union? : Sql dba
What is trigger point?
How delete all records from table in sql?
what are the nonstandard string types? : Sql dba
What is constant in pl sql?
Define SQL and state the differences between SQL and other conventional programming Languages?
Explain the rollback statement?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is record type in pl sql?
Is sql database free?
What is bulk compiling in pl/sql.?
