Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6797 Views
- Adea, I also Faced
- E-Mail Answers
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
What is range partitioning?
Can we perform dml on view?
What does fetching a cursor do?
What are the key differences between SQL and PL SQL?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is sql partition function?
give the syntax of grant and revoke commands? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
Is primary key a clustered index?
Which are the different types of indexes in sql?
What are the types of dbms?
What is union and union all keyword in sql and what are their differences?
What is the difference between count 1 and count (*) in a sql query?
How many types of triggers are there in pl sql?
What is a primary key sql?
