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




Answers were Sorted based on User's Feedback



I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books ar..

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

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books ar..

Answer / oraclecodec

There must be some column such as 'TECHNOLOGY' that should
distinguish java ,.net and ABC apart from their versions.
Then its easier to arrive at a solution

SELECT TECHNOLOGY,COUNT(*) FROM BOOK GROUP BY TECHNOLOGY;

Is This Answer Correct ?    8 Yes 3 No

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books ar..

Answer / arunarevathi.s

hi seenu,
in this table have three coloumn thats are
book,version,numofbooks.
The query for u,
sql>select book,sum(numofbook)as count from book
group by book;


By,
aruna

Is This Answer Correct ?    4 Yes 0 No




I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books ar..

Answer / suman maan

select substring(trade,1,(len(trade)-3)) as
trade,sum(no_ofbooks)
from test
group by substring(trade,1,(len(trade)-3))


Trade is bookname like(java1.1,.Net305)
no_ofbooks as indivisual book count

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

Define implicit and explicit cursors.

0 Answers  


What is a call statement? Explain with an example.

0 Answers  


define sql

3 Answers   Zensar,


If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  


What is a trigger in sql?

0 Answers  






How can you know that statistics should be updated?

0 Answers  


How is a process of pl/sql compiled?

0 Answers  


7. Where would you look for errors from the database design?

1 Answers   Fintellix,


while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,


What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,


Types of locks in database ?

8 Answers   HCL, TCS, Tieto,


What is a cursor ? Why Cursor is required ?

3 Answers  






Categories