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 6401what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
1 4142How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
5 10638
What is query_cache_limit?
What are the various data types available in db2?
Where do you specify them?
How do I add a column to an existing table in db2?
Explain correlated sub-queries.
What is a plan and package in db2?
is it compulsory commitment control in journal?
Can we insert update delete in view?
What are types of indexes?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What language is db2 written in?
How to find the number of rows in a db2 table?
How do I start db2 in windows?
Explain how can you do the explain of a dynamic sql statement?
what is the responsibility of the construction superintendent