select A.yr, count(*) from (select year(doj) from emp

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 / m4io

9 Answers
14320 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / m4io

select A.yr, count(*) from
(select year(doj) from emp_tbl) A
group by a.yr

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a db2 collection?

1053

Which component is responsible for db2 startup and shutdown?

1038

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.

2727

What is db2 bind?

1089

What is difference between alias and synonym in db2?

1149

What is package in cobol db2?

1121

What is declare cursor?

1127

What do you mean by between and in? Is between inclusive of specified range values?

1092

Explain packages.

1116

Before you give the explain statement, what are the prerogatives?

1044

Is db2 a mainframe database?

1006

What are the full forms of spufi and dclgen and why are they used?

1094

Highlight all the advantages that are attached to a package.

1121

Can we delete records from view?

972

What is copy pending and check pending in db2?

1007