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

2 Answers   IBM,

---

what is db2 restart?

0 Answers  

---

What is QUIESCE?

2 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---

what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

How could one combine a set of incremental image copies into a single copy?

1 Answers  

---

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

---