Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14256 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rama krishna reddy
Hi harish,
the query you mentioned will give diffrent result like
col1 count
---------- --------
2007-03-19 1
2007-05-19 2
2008-05-19 1
2009-05-19 2
2004-05-19 1
but the number of students joined in 2007 is 3 but is
showing in 2 diff lines in the output for ur query
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what are bind concepts in db2 cobol?
How do I create a view in db2?
What is the role of union all and union
What is db2 stogroup?
What os does db2 run on?
What are iseries servers?
i want to maintain uniqueness on pdf without make lf??????????
How does cobol compile db2 program?
What is the difference between using bind () and rebind () methods of naming class?
What is db2 look?
What is the clustering index in the db2 database?
What is ibm db2 connect?
How do I copy a table in db2?
What is the meaning concurrency in the db2 database?
What is the maximum size of a char data type in db2?
