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
14677 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 blu acceleration in db2?

1129

Explain in detail about buffer manager and its functionalities?

1145

What is a db2 collection?

1107

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.

2774

What is scrollable cursor in db2?

1126

Explain packages.

1171

How to run db2 command in windows?

1245

Mention the definition of cobol in varchar field.

1315

What does sqlcabc has?

1098

Is db2 a mainframe database?

1049

What is the use of value function?

1209

How many types of page locks can be held in db2?

1090

What is difference between isnull and coalesce?

1106

How to find primary key of a table in db2?

1125

List down the types of triggers in the db2 database?

1079