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
- 4 Answers
- 6071 Views
- Adea, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a natural join sql?
how to check myisam tables for errors? : Sql dba
Can a key be both primary and foreign?
What is the basic form of sql query?
What are the possible values that can be stored in a boolean data field?
What are the two virtual tables available at the time of database trigger execution?
what is a database transaction? : Sql dba
Explain the steps needed to create the scheduled job?
What is the advantage of nosql?
What are the advantages of pl sql?
What is clause?
what happens if you no create privilege in a database? : Sql dba
Can I learn sql in a week?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is package in pl sql?
