Hi, You can write the query as below: select year(doj) as year, count

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 / amita sharma

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

Answer Posted / amita sharma

Hi,

You can write the query as below:

select year(doj) as year, count(*) as count from emp_join
group by year(doj);

Let: table name is: emp_join

For furthur clarifications or queries please ask.

Thanks;
Amita Sharma.

Output:

year count

2004 1
2007 3
2008 1
2009 2

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is load utility in db2?

1182

Why do we bind in db2?

1216

How to execute stored procedure in db2 command editor?

1052

How can you do the explain of a dynamic sql statement?

1069

What is null indicator in db2?

1117

Define buffer pool.

1062

Explain db2.

1041

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1109

What is cascading rollback?

1218

What is the difference between oracle and db2?

1112

Discuss about db2 bind?

1103

Mention the different locking levels that are available in db2.

1138

What is data manager?

1056

How do I copy a table in db2?

1003

Explain in detail about buffer manager and its functionalities?

1070