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
14249 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 is db2 bind?

1076

What is node in db2?

1042

List down the types of triggers in the db2 database?

1022

What is the syntax for FETCH in DB2 ?

1204

What is schema in db2?

1018

What is the use of predicate?

1039

What is the cobol picture clause of the db2 data types date, time, timestamp?

1053

What is db2 command?

1029

List out the data types available.

1148

What is db2 and what is the use of db2 optimizer?

1055

What is the latest version of ibm db2?

1263

What is coalesce in db2?

1128

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2176

Are view updateable?

1039

What is bufferpool in db2?

1046