Hi Seenu, Please find the Query below. select rtrim(bk

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 / ravi

4 Answers
6803 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

Please Help Members By Posting Answers For Below Questions

What port does sql server use?

1057

what is the difference between delete and truncate statement in sql? : Sql dba

1235

What are the commands used in sql?

1070

What is the process of debugging?

1063

What is a table partition?

1125

What does truncate mean in sql?

1017

What is procedure explain with program?

1015

Where is all the data on the internet stored?

1007

What is a nested table in word?

952

what is oracle database ? : Sql dba

1019

Can we call a function containing dml statements in a select query?

969

Define commit, rollback and savepoint?

1021

What is the execution plan in sql?

1018

What is the advantage of index in sql?

967

Which join is default?

949