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 6648what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
1 4296How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
5 11013
What is a Foreign Key?
What db2 400?
How many types of page locks can be held in db2?
How to find the number of rows in db2 tables?
Define data page.
How do I import data from excel to db2?
What is rebind in db2?
What are the two types of logging in the db2 database? Explain them.
How do I optimize a query in db2?
Describe major components of db2?
What is a buffer in memory?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How to check table size in db2 sap?
How is deadlock resolved?
When the like statement is used?