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
6652 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 is the use of dclgen in db2?

1135

How to compare data between two tables in db2?

1139

What is db2 catalog database?

1091

What is the use of db2 optimizer?

1175

What is package in cobol db2?

1163

What does db2 blu stand for?

1219

Name the lockable units in DB2?

1187

What is sqlca?

1133

What is the role of schema in the db2 database?

1362

What is a trigger in the db2 database?

1143

What is a db2 cursor?

1109

What is catalog database in db2?

1218

What is the physical storage length of time data type?

1178

What is the use of with ur in db2?

1108

Explain correlated sub-queries.

1096