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
6398 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 maximum No of rows per page?

1010

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1029

How do we specify index to include or not during bind process.

2069

What is the difference between cursor stability and repeatable read isolation levels?

1113

What is a db2 cursor?

1004

What is the difference between using bind () and rebind () methods of naming class?

1324

How to resolve deadlock issue

19857

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

1098

i want to maintain uniqueness on pdf without make lf??????????

2097

What is a page in db2?

979

What is innodb buffer pool?

975

can we view the access paths created by dbrm ? how ? thx

6971

What is a Foreign Key?

1036

What are host variables in db2?

989

What is the use of value function?

1073