select country,sum(salesamt) from table1 groupby country; but if its pri

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

Question Posted / satty

2 Answers
6560 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is deadlock in db2?

1076

How does a cursor work?

995

Can we delete records from view?

974

What is a system catalog table in db2?

1195

What is explain plan in db2?

1008

What are foreign keys in db2?

1114

Define declaration generator (dclgen).

1123

What is a buffer in memory?

1069

What are db2 tables?

1133

How is the value function used?

1159

What is the role of data manager in the db2 database?

1112

Why do we need reorg in db2?

998

What is iseries database?

1058

How do I add a column in db2?

1054

Give a brief description of db2 isolation levels?

1078