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
11367 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 the sqlcode -501

11326

What are the various isolation levels possible?

656

What is dbrm? When it will be created?

606

What are types of indexes?

600

What are the two types of logging in the db2 database? Explain them.

585

What is cursor stability in db2?

819

What is the difference between db2 and oracle?

685

What is a page in db2?

618

Which isolation level provides highest data integrity?

605

What is db2 bind?

644

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10805

Define sqlca.

655

How do I start db2 in windows?

578

Define buffer pool.

634

What is the use of db2?

596