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

How many types of page locks can be held in db2?

1038

What is rebind in db2?

1052

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1083

How can deadlocks be resolved?

930

What is the use of value function?

1147

Explain package in db2 and its advantages?

1208

Why do we bind in db2?

1207

Outputs of explain are with matchcols = 0. What does this signify?

1051

What are iseries servers?

1071

What is the use of dclgen in db2?

1082

Can we delete records from view?

963

How do you pull up a query which was previously saved in qmf?

1148

Which isolation level provides maximum concurrency?

1150

What is an instance database?

1048

How do I add a column in db2?

1046