Answer / sunil1405

join is more efficeint, Subselect can be written as a join.

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers   IBM,

---

I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!

17 Answers   KNIT, Tech Mahindra,

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

Give the name of some fields form sqlca.

0 Answers  

---

Which transaction use a command thread ?

1 Answers  

---

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

---

What types of tables are there in the db2 database?

0 Answers  

---

What is a precompiler?

2 Answers  

---

what is a collection?

2 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

Compare a subselect to a join?

1 Answers  

---

Why select is not preferred in embedded sql programs?

0 Answers  

---