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

When do you specify the isolation level?

1028

Explain package in db2 and its advantages?

1212

On which levels locks can be applied?

1123

Mention the different locking levels that are available in db2.

1127

What is the picture clause of null indicator variable?

1136

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1080

What are packages in db2?

1019

What are the different types of base tables?

1089

What is blu acceleration in db2?

1069

What is the difference between dbm cfg and db cfg file in db2 ?

1531

What is rebind in db2?

1053

What is cursor stability in db2?

1354

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1274

What is the use of reorg in db2?

1081

How to take backup of table in db2?

1071