select distinct substr(DOJ,(1,4)),count(*) 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 / sambit mohapatra

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

Answer Posted / sambit mohapatra

select distinct substr(DOJ,(1,4)),count(*) from emp_tbl
group by DOJ

I hope that this quey is work fine and let me know the
result.

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 db2 optimizer?

1230

How does a cursor work?

983

How to execute stored procedure in db2 command editor?

1047

Highlight all the advantages that are attached to a package.

1113

What is db2 bind?

1079

What is reorg?

1153

What os does db2 run on?

978

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2210

What r the comman abends in db2, jcl and cobol???????

2250

Explain the contents that are a part of dclgen.

1089

How to check sequence on a table in db2?

1056

Can we update view in db2?

1000

What is load utility in db2?

1179

What is cursor stability in db2?

1354

Mention the definition of cobol in varchar field.

1246