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
13839 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 type of database is db2?

913

Explain in brief how does db2 determine what lock-size to use?

961

How do I import a csv file into db2?

938

How does a cursor work?

931

How will you return the number of records in table?

882

What is performance tuning db2?

1010

What is the syntax for creating a table in the db2 database?

1060

Mention the downsides of page level lock.

1112

Name the lockable units in DB2?

1075

What is a db2 cursor?

1009

What is db2 bind process?

1183

Outputs of explain are with matchcols = 0. What does this signify?

992

Explain correlated sub-queries.

979

How to find the maximum value in a column in the db2 database?

1018

Who uses db2?

985