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
difference between group clause and order clause1 4223
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........1 3257
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement5 8196
What is -904 sql code? How to resolve it?3 39369
What is a collection in db2?
What is release/acquire in bind?
What is with ur in db2?
What are the various data types available in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
what is the sqlcode -501
What are the contents of dclgen?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is db2 stogroup?
How to execute stored procedure in db2 command editor?
What do you mean by commit and rollback?
What is scrollable cursor in db2?
How to take backup of table in db2?
What is the role of schema in the db2 database?
Is db2 relational database?