Answer / saikishore

select TIMESTAMP(DATECOLUMN)
FROM TABLE1

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,

---

Define db2.

0 Answers  

---

What is a dbrm in db2?

0 Answers  

---

How to update more then one record using update?

5 Answers   IBM,

---

What is the result of open cursor statement?

0 Answers  

---

---

Describe major components of db2?

0 Answers  

---

i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---

What is query_cache_limit?

0 Answers  

---

Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,

---

Why do we bind in db2?

0 Answers  

---

What is a bind card?

0 Answers  

---

cobol-db2 runjcl please?

2 Answers   DELL,

---