What is db2 purescale?
No Answer is Posted For this Question
Be the First to Post Answer
Which catalog tables contain authorization information?
How will fetch last 5 rows from table in db2
What is a view? Why use it?
How does db2 sample database connect?
How can we retrieve the total number of records in RPG & CLLE?
What is db2 bind process?
What are host variables in db2?
How are write I/Os from the buffer pool executed?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is buffer pool?
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