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
6641 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 are sql constraints?

1127

What is a behavioral trigger?

932

What is difference between pls_integer and integer?

910

How do you get column names only for a table (sql server)?

1102

What is sql indexing?

965

How will you distinguish a global variable with a local variable in pl/sql?

1093

Do prepared statements prevent sql injection?

898

What is form and report?

929

What does select top 1 do in sql?

1007

what is clause? : Sql dba

1006

What is delimiter sql?

924

How can you load multi line records? : aql loader

1022

What is meant by <> in sql?

895

Is record in oracle pl sql?

904

How can you fetch common records from two tables?

1004