Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6650 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satty
select country,sum(salesamt) from table1 groupby country;
but if its primary key is cust-no, then it will show error
-803 try to insert duplicates in primary key value.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / raghu
select country,sum(salesamt) from table1 where country = ind;
| Is This Answer Correct ? | 0 Yes | 1 No |
How to rename a table in DB2 ?
pls explain the precompilation process of cobol-db2 pgm
What are host variables in db2?
What is a DB2 access path?
How to retrieve rows from a db2 table in embedded sql?
How to resolve -803 sql code in DB2?
What information is contained in a SYSCOPY entry?
What is the function of the Data Manager?
How does DB2 use multiple table indexes?
How many Buffer pools are there in DB2 and what are they?
Highlight all the advantages that are attached to a package.
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 ?
COBOL 
