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
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 |
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
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 |
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 |
What is the basic structure of PL/SQL ?
how will you find out the last three records in a table with n no of records and delete them
How to write pl sql program in mysql command prompt?
Why do we need a foreign key?
What is sql character function?
What is the difference between an inner join and an outer join?
What is a nested table in word?
how to enter numeric values as hex numbers? : Sql dba
What is the reports view in oracle sql developer?
what is the difference between clustered and non clustered index in sql? : Sql dba
What are conditional predicates?
what is sql profiler
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)