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
- 6404 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 |
What is dbrm? When it will be created?
Name some fields from SQLCA.
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is rct?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
How to resolve -502 sql code in DB2?
What does runstats do in db2?
What are the levels of isolation available with DB2V4
How can you quickly find out the # of rows updated after an update statement?
Outputs of explain are with matchcols = 0. What does this signify?
What are the abend codes occour in ur latest PROJECT in DB2
what is the use of commit ? and what is the syntax?
COBOL 
