how can we find nth max salary from A table

5 Answers   IBM,

---

What are the prerogatives?

0 Answers  

---

How do I connect my db2 database to ibm?

0 Answers  

---

For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?

1 Answers   BNP Paribas,

---

Mention the different locking levels that are available in db2.

0 Answers  

---

How can you get the number of rows impacted by the last executed query?

1 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,

---

What is a db2 tablespace?

0 Answers  

---

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

0 Answers  

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---

Which isolation level provides maximum concurrency?

0 Answers  

---

Is ibm db2 free?

0 Answers  

---