Answer / prachi

SELECT * FROM TABLENAME
FETCH FIRST 100 ROWS ONLY;

This will fetch 1st 100 records

Answer / ankit.:-)

if u want to fetch first 100 go for

select * from tablename fetch only 100 rows;

this will select only 100

Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?

1 Answers   IBM,

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

On which levels locks can be applied?

0 Answers  

---

What is a Cartesian product?

2 Answers  

---

Explain various types of locks in db2?

0 Answers  

---

What does the RUNSTATS Utility do?

4 Answers  

---

What is the picture clause of null indicator variable?

0 Answers  

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

0 Answers  

---

What is auditing?

2 Answers  

---

db2 restart logic ?

1 Answers   DELL, HTC, UHG,

---

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

---