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

Name the various locking levels available?

1035

What is db2? Explain.

989

What is a db2 package?

991

Give the name of some fields form sqlca.

1024

What is difference between isnull and coalesce?

1010

Mention the different locking levels that are available in db2.

1073

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

1051

How do I change the column size in db2?

1084

What is a storage group (stogroup)?

1189

Highlight all the advantages that are attached to a package.

1075

What do you mean by storage group (stogroup)?

984

What is load utility in db2?

1132

What is innodb buffer pool?

982

What is a collection in db2?

986

What is null in db2?

950