Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6833 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
How to find 3rd highest salary of an employee from the employee table in sql?
What are sql injection vulnerabilities?
What are the different type of joins in sql?
What is difference between hql and native sql?
how to shut down the server with 'mysqladmin'? : Sql dba
What is sql stand for?
Explain the structure of pl/sql in brief.
What is snowflake sql?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What are functions in sql?
Write the command to remove all players named sachin from the players table.
What is sql data?
Why do we use joins?
What is sql prepared statement?
What are the different datatypes available in PL/SQL?
