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
6996 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

How do you change a value in sql?

1067

Why select is used in sql?

1070

Explain the advantages and disadvantages of stored procedure?

1198

What are sql triggers used for?

1035

How to create an array in pl/sql?

1122

how to convert numeric values to character strings? : Sql dba

1160

Why are sql stored procedures used?

1095

What is schema in sql example?

1278

How do I make my sql query run faster?

1017

Does google use sql?

1007

Why stored procedure is better than query?

1002

What is the purpose of the partition table?

1089

Which normal form is best?

998

Where not exists in sql?

1032

Is a view faster than a stored procedure?

1012