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
14319 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

How do I optimize a query in db2?

1105

What is universal database?

1074

What is meant by dclgen?

1115

Discuss about db2 bind?

1103

How to find primary key of a table in db2?

1066

What is clone table?

1054

What is cursor with hold option in db2?

1084

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1111

How to retrieve rows from a db2 table in embedded sql?

1397

Why do we need reorg in db2?

993

What is a db2 collection?

1053

What is the use of db2?

1060

What is difference between alias and synonym in db2?

1148

What is image copy in db2?

1023

What is the maximum number of columns in a db2 table?

1289