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 5469what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
1 3479How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
5 8904
How can you count the number of rows from a table tab?
What is innodb buffer pool?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is syscat in db2?
What is meant by dclgen?
What is declare cursor?
What types of tables are there in the db2 database?
How to find the number of rows in db2 tables?
What is the default page size of buffer pools?
What are db2 tables?
What is difference between rollback and commit?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a bind card?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the physical storage length of date data type?