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
14681 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 are concurrency issues?

1172

Which command is used to connect to a database in DB2 ? Give the Syntax.

1151

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1132

Define predicate?

1204

Mention the location where the output received from explain statement is stored.

1174

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1788

Can you tell me how can you find out the # of rows updated after an update statement?

1147

What is the maximum length of sqlca?

1614

What is schema in db2?

1081

What is dbrm library?

1114

What is table space in db2?

1072

Which command is used to remove all rows from a table?

1183

What is a db2 tablespace?

1120

What is the max length of sqlca?

1271

What do you mean by storage group (stogroup)?

1083