Answer / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Answer / jagan

select top 100 from tableName;

What are the prerogatives?

0 Answers  

---

Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

Name the different types of Table spaces.

5 Answers   IBM,

---

What db2 400?

0 Answers  

---

What is lock contention?

1 Answers  

---

What is precompiler in db2?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

What is db2 plan table?

0 Answers  

---

cursor with hold explain ?

1 Answers   Verizon,

---

Mention the definition of cobol in varchar field.

0 Answers  

---