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
Answer Posted / 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 |
Post New Answer View All Answers
Explain the rollback statement?
what is 'trigger' in sql? : Sql dba
What is the maximum number of rows in sql table?
How do I restart sql?
What is scalar data type in pl sql?
How does index help in query performance?
Does execute immediate commit?
Write the command to remove all players named sachin from the players table.
What is difference between inner join and cross join?
What are operators available in sql?
What does select * from mean in sql?
What is record type in pl sql?
Why do we need cursor in pl 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 is difference between cursor and trigger?