Answer / sesha

SELECT * FROM TABLE
FETCH FIRST 100 ROWS
ONLY

Answer / jagan

select top 100 from tableName;

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

2 Answers   Cap Gemini,

---

select 100 records from million records ?

2 Answers   Verizon,

---

What is schema in db2?

0 Answers  

---

What is innodb buffer pool?

0 Answers  

---

---

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,

---

how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,

---

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

---

Which isolation level provides highest data integrity?

0 Answers  

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---