What is phantom read in db2?

0 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

What is the difference between bind and rebind in db2?

0 Answers  

---

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

Where is the output of EXPLAIN stored?

2 Answers  

---

What is UNION,UNION ALL?

2 Answers  

---

What is a bind card?

0 Answers  

---

What is read-only cursor?

1 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

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,

---