Answer / abirami

select max(salary) from tablename
fetch first 10 rows only

What is a trigger in the db2 database?

0 Answers  

---

how many bytes timestamp token occupies?

6 Answers   Boss Global, Cap Gemini, TCS,

---

Which command is used to connect to a database in DB2 ? Give the Syntax.

0 Answers   MCN Solutions,

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,

---

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,

---

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

1 Answers  

---

How can you quickly find out the # of rows updated after an update statement?

0 Answers  

---

How can you do the explain of a dynamic sql statement?

0 Answers  

---

How to execute stored procedure in db2 command editor?

0 Answers  

---

What is collection in db2 bind?

0 Answers  

---

how to execute qcmdexc in rpgle?plz write code also?

1 Answers   IBM,

---