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
- 6022 Views
- Adea, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why should I use postgresql?
Which constraints we can use while creating database in sql?
Which one is faster ienumerable or iqueryable?
What is the sql query to display the current date?
How do I view stored procedures?
Why are indexes and views important to an organization?
What is difference between stored procedures and application procedures?
What is character functions?
What are the three forms of normalization?
Can I learn sql in a week?
Compare sql & pl/sql
How many parts of a pl sql block are optional?
What is pivot in sql?
how to convert character strings to dates? : Sql dba
Why procedure is used in sql?
