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
For this i need sql query, please help me if anyone how to
get this result.
Answers were Sorted based on User's Feedback
Answer / ravi
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
In case of doubts do feel free to ask.
|Is This Answer Correct ?||8 Yes||0 No|
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|
Answer / arunarevathi.s
in this table have three coloumn thats are
The query for u,
sql>select book,sum(numofbook)as count from book
group by book;
|Is This Answer Correct ?||4 Yes||0 No|
Answer / suman maan
select substring(trade,1,(len(trade)-3)) as
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|
Define implicit and explicit cursors.
What is a call statement? Explain with an example.
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
What is a trigger in sql?
How can you know that statistics should be updated?
How is a process of pl/sql compiled?
7. Where would you look for errors from the database design?
while loading data into database how can u skip header and footer records in sql*loader
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
Types of locks in database ?
What is a cursor ? Why Cursor is required ?