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
- 6017 Views
- Adea, I also Faced
- E-Mail Answers
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
how to create a new view in mysql? : Sql dba
What are literals in sql server?
What is sql mysql pl sql oracle?
What is a sql select statement?
What is the difference between joins?
What is an escape character in sql?
What are the different types of functions in sql?
Why does sql need a server?
How many developers work on postgresql?
What is implicit cursor in pl sql?
Difference between table function and pipelined function?
What is trigger and how to use it in sql?
What is the execution plan in sql?
What is union?
What is sql and db2?
