Do we need cursor for Count(*)?

4 Answers   iGate,

---

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,

---

Are views updateable?

0 Answers  

---

if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)

3 Answers  

---

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

how can u understand the end of the table ?

1 Answers   TCS,

---

What is a subselect? Is it different from a nested select?

1 Answers  

---

What is the advantage in De-normalizing tables in DB2?

0 Answers  

---

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

3 Answers  

---

how to unload different table data into different gdg files/ vsam files.

3 Answers  

---