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
What is partition by in sql?
How run sql*plus commands that are stored in a local file?
What is materialized view. What are different methods of refresh?
What is procedure function?
What are the different set operators available in sql?
What is a left inner join?
What is example of database?
Advantages and disadvantages of stored procedure?
How do you use a while loop in pl sql?
What is auto increment in sql?
How to use transactions efficiently : transact sql
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
How is pl sql different from sql?
Explain commit, rollback and savepoint.
How many scalar data types are supported in pl/sql?