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
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 the use of dclgen in db2?
Which isolation level provides maximum concurrency?
What is the syntax for FETCH in DB2 ?
What is the use of db2?
What is load utility in db2?
What is a db2 collection?
How to find the maximum value in a column in the db2 database?
What is the clustering index in the db2 database?
What is the difference between db2 and oracle?
What is catalog database in db2?
Explain what are the various isolation levels possible?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What are the bind parameters ibm db2?
What is performance tuning db2?
What is db2 and what is the use of db2 optimizer?