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
Are dml statements autocommit?
What is output spooling in sql*plus?
What are the types of functions in sql?
What are different joins used in sql?
Name some usages of database trigger?
Is a foreign key always unique?
What is the difference between a subquery and a join?
What does the sign mean in sql?
What is materialized view in sql?
how to decrement dates by 1 in mysql? : Sql dba
What is embedded sql what are its advantages?
Is sql a microsoft product?
what is data control language? : Sql dba
What are the string functions in sql?
What is the difference between clustered and non-clustered indexes?