I have a table name Table1 which contain columns Cust_no,
car_model, country, salesamt. The records are 101, Fiat,
India, 12345
2nd record is 102, Tata, USA, 98743 3rd record is 101,
indica, India, 65342 4th record is 103, Toyota, UK, 64522
5th record is 103, Maruti, USA, 98632 and so on.....
Now my question is write sql query which will give me
detail about the sum of sales amount in perticular country
- 2 Answers
- 5753 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / raghu
select country,sum(salesamt) from table1 where country = ind;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is release/acquire in bind?
What is buffer pool and list some of them?
What are the full forms of spufi and dclgen and why are they used?
Which component is used to execute the sql statements?
What does db2 plan contain?
How can we retrieve the total number of records in RPG & CLLE?
What is the syntax for FETCH in DB2 ?
What is blu acceleration in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How to execute stored procedures?
How do I delete a table in db2?
what is a corelated subquerry?
can we view the access paths created by dbrm ? how ? thx
Can one database have multiple instances?
Discuss about db2 bind?
