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
- 13841 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
What is view db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is null indicator in db2?
What is the difference between nvl and coalesce?
Explain about cursor stability?
What is the use of predicate?
What is collection in db2 bind?
What is host variable in db2 cobol?
What is scrollable cursor in db2?
How does db2 sample database connect?
Mention the various locks that are available in db2.
How connect db2 database to datastage?
What does db2 blu stand for?
What are the various isolation levels possible?
what is a corelated subquerry?
