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
- 13818 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 is the maximum length of sqlca?
What is a db2 collection?
What are foreign keys in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is cursor with hold option in db2?
When do you specify the isolation level?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How to resolve deadlock issue
What is rct?
What is the use of with ur in db2?
Can we insert update delete in view?
What is check constraint. Explain with example.
What is the purpose of rollback and commit?
What is db2 bind?
What are the different types of base tables?
