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

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;

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

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

What is a sql*loader control file?

0 Answers  

---

What are the subsets of sql?

0 Answers  

---

What are the Restrictions on Cursor Variables?

2 Answers  

---

i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

Who is the owner of mysql database?

0 Answers  

---

what are the disadvantages of mysql? : Sql dba

0 Answers  

---

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

What are sql triggers used for?

0 Answers  

---