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
IBM,
2 6460what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
1 4168How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
5 10719
What is difference between rollback and commit?
What is the difference between bind and rebind in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How do I import data from excel to db2?
What is the difference between using bind () and rebind () methods of naming class?
What is catalog database in db2?
Are views updateable?
What is a bind in db2?
How is deadlock resolved?
What is a db2 collection?
How can we read records for specific member in CL? AND rpg?
Define predicate?
What is package in db2 mainframe?
How to take backup of table in db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?