What is consistency token in db2?

0 Answers  

---

My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

What is a SELECT statement?

1 Answers  

---

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

---

How do you stop a db2 database in linux?

0 Answers  

---

---

What is a clustered index?

1 Answers  

---

What is the picture clause of the null indicator variable?

6 Answers  

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

---

What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,

---

WHAT IS MEANT BY COMMIT COMMAND?

7 Answers   Wipro,

---

What is deadlock in db2?

0 Answers  

---