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
6651 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

How to view db2 table structure?

1067

What is the difference between drop table and delete table?

1288

What is dbrm? When it will be created?

1089

What is runstats and reorg in db2?

1362

Explain about rct.

1131

What is the role of schema in the db2 database?

1362

Explain db2.

1087

List down the types of triggers in the db2 database?

1079

What is the default page size of buffer pools?

1171

Is db2 relational database?

1044

What is the difference between nvl and coalesce?

1107

How can you find out the # of rows updated after an update statement?

1154

What is cobol db2?

1046

What is with ur in db2?

1384

Who uses db2?

1112