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
Answers were Sorted based on User's Feedback
Answer / ravi
Hi Seenu,
Please find the Query below.
select rtrim(bk_nm,'0123456789.'),sum(bk_cnt) from books
group by rtrim(bk_nm,'0123456789.')
where bk_nm is the name of the books you wrote and bk_cnt
is their individual count. Run this Query and you'll get
your answer.
In case of doubts do feel free to ask.
Thanks,
Ravi Jha
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / oraclecodec
There must be some column such as 'TECHNOLOGY' that should
distinguish java ,.net and ABC apart from their versions.
Then its easier to arrive at a solution
SELECT TECHNOLOGY,COUNT(*) FROM BOOK GROUP BY TECHNOLOGY;
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / 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 |
Answer / 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 |
What is inner join in sql?
Why we use stored procedure instead of query?
write a query find which rows of a table is updated on 2 days before?
what is Difference between Having and Where clause?
Types of joins ?
Does mysql support pl sql?
Is subquery faster than join?
What is an oracle stored procedure?
What is triggering circuit?
Explain exception handling in pl/sql?
Why we use join in sql?
What is the maximum number of triggers,can apply to a single table?