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
6710 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 I run a script in sql developer?

916

How do you clear the screen in sql?

1032

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1020

Can we join more than 2 tables in sql?

977

How do I create a memory optimized filegroup?

919

How many sql databases can you have on one server?

1042

Why functions are used in sql?

955

What is procedure function?

1010

What is bulk collect in pl sql?

1055

How do you create an update query?

932

What is sql*loader and what is it used for?

1081

What is java sql drivermanager?

1045

What are the different types of triggers?

1086

How to return an array from java to pl/sql?

1083

What is a temporal table?

905