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
14333 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 db2 400?

1206

Explain the benefits you can get from mainframe connect?

976

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

1037

List out the three types of page locks that can be held.

1151

What is the role of schema in the db2 database?

1281

Explain db2.

1043

Is db2 a programming language?

1057

What is db2 purescale?

1012

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1245

What is catalog database in db2?

1172

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1279

Which isolation level provides highest data integrity?

1130

How do you select a row using indexes in db2?

1142

Define db2.

1121

What is buffer pool and list some of them?

1046