select country,sum(salesamt) from table1 where country = ind;

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 / raghu

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

Answer Posted / raghu

select country,sum(salesamt) from table1 where country = ind;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are iseries servers?

1076

What happens in bind step in a db2 program?

974

What are the uses of db2 optimizer?

1296

Are view updateable?

1046

Explain various types of locks in db2?

1158

How to connect to db2 database from windows command line?

1066

What is the syntax for FETCH in DB2 ?

1216

Explain the contention situations caused by locks?

1071

What is scrollable cursor in db2?

1056

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1241

What is cobol db2?

1003

Why select is not preferred in embedded sql programs?

1302

What is db2 look?

1026

What is iseries database?

1051

Why cursor is used in db2?

1036