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
- 11339 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain about mirror activator disk mirroring?
What are types of indexes?
How would the varchar column remarks defined?
What are the bind parameters ibm db2?
How to get the ddl of a table in db2?
What is phantom read in db2?
What is a bind in db2?
What do you mean by storage group (stogroup)?
What types of tables are there in the db2 database?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
Is db2 a programming language?
Can we insert update delete in view?
List some fields from sqlca?
How many types of page locks can be held in db2?
How to check sequence on a table in db2?
