Hi Rama Krishna Reddy, What you tried in db2 and oracle i dont know but

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

Question Posted / saeed

9 Answers
14266 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

Please Help Members By Posting Answers For Below Questions

What is db2 command?

1032

What is rebind in db2?

1053

What is package in db2 mainframe?

985

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2386

How do I create a view in db2?

1020

what is diffrence b/w file-aid tool and file-aid utility???

4888

How would the varchar column remarks defined?

1086

Explain about cursor stability?

1046

How do I add a column to an existing table in db2?

1030

What is dbrm?

1105

How to find schema of a table in db2?

1012

What is scrollable cursor in db2?

1055

How and when does the db2 enforces the unique key?

1083

Define predicate?

1129

Is db2 relational database?

973