Answer / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Answer / jagan

select top 100 from tableName;

What is commit in db2?

0 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

What is dclgen (declaration generator)?

0 Answers  

---

How to resolve deadlock issue

5 Answers   IBM,

---

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,

---

What is the logical entity between plan and Package?

5 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

when does the SQL statement gets executed when you use cursor in the application programming ?

3 Answers   IBM,

---

How to check table size in db2 sap?

0 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

What is netezza database?

0 Answers  

---

What is Reorg Recovery? when will you run it?

2 Answers  

---