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,

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,

---

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  

---

What is drop table?

0 Answers  

---

What are the benefits of using the db2 database?

0 Answers  

---

How are write I/Os from the buffer pool executed?

1 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

What is sqlcode -922 ?

2 Answers  

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

What is meant by explain?

0 Answers  

---