Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The record..

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

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The record..

Answer / raghu

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is a DB2 plan?

8 Answers  

Is db2 a programming language?

0 Answers  

What is iseries database?

0 Answers  

What is reorg in DB2

3 Answers   Virtusa,

Explain about rct.

0 Answers  

What is runstats utility in db2?

0 Answers  

Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,

What does the sqlcode of -818 pertain to?

3 Answers  

What is clone table?

0 Answers  

What is ibm db2 connect?

0 Answers  

What is a DB2 bind?

1 Answers   Logica CMG,

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

For more DB2 Interview Questions Click Here
Categories