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 / 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 get a list of all tables in a database? : Sql dba
How to run pl sql program in mysql?
what is self-join? : Sql dba
List different type of expressions with the example.
What is a sql instance vs database?
Can ddl statements be used in pl/sql?
How do I view tables in mysql?
How subquery works in sql?
Explain what is sql?
What are the uses of merge?
what are date and time functions in mysql? : Sql dba
How to know the last executed procedure?
How can you save or place your msg in a table?
What is %type in pl sql?
What is a delimiter in sas?