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
Answer Posted / saeed
Hi Rama Krishna Reddy,
What you tried in db2 and oracle i dont know but year() can
be used in DB2 ver 9.5, and the result of above query
posted by Amita Sharma might not be correct but which
functions she used is correct .
As per my opinion following qry can give desired result.
SELECT DISTINCT YEAR(DOJ) AS YEAR , COUNT(*) AS COUNT FROM
TABNAME GROUP BY YEAR(DOJ)
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is dbrm? What it contains? When it will be created?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is the advantage in De-normalizing tables in DB2?
What is null value in db2?
Which component is responsible for processing sql statements and selecting access paths?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How can record locking be achieved in those DB2 versions which do not support it?
What is dclgen in db2?
What is the purpose of using commit?
Is db2 a programming language?
Define check constraint.
What type of database is db2?
Explain about open switch business continuity software?
Outputs of explain are with matchcols = 0. What does this signify?
What is the picture clause of null indicator variable?