It should work this way also... SELECT X.YEAR, COUNT(X.SNAME) FROM ( S

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 / raj

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

Answer Posted / raj

It should work this way also...

SELECT X.YEAR, COUNT(X.SNAME)
FROM (
SELECT SUBSTR(DOJ,1,4) AS YEAR, SNAME
FROM EMP_TBL
) X
GROUP BY X.YEAR;

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 the physical storage length of time data type?

1129

How do I add a column to a table in db2?

1104

What is check constraint in db2?

1090

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2248

What is db2 look?

1025

What type of database is db2?

971

what is db2 restart?

2162

B37 abend during spufi?

1455

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1092

What r the comman abends in db2, jcl and cobol???????

2254

Which is faster delete or truncate?

1128

What does db2 mean?

1017

What is a db2 tablespace?

1066

What is db2 stogroup?

1160

What is a collection in db2?

1036