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

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

1096

List down the data types in the db2 database.

1115

What is temporal table in db2?

1035

What does db2 stand for?

1020

What is db2?

1175

what are bind concepts in db2 cobol?

1090

What are concurrency issues?

1094

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1234

What is deadlock in db2?

1062

What is rebind in db2?

1052

What are the bind parameters ibm db2?

1046

Is ibm db2 open source?

1070

If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1146

Which component is responsible for processing sql statements and selecting access paths?

1126

Before you give the explain statement, what are the prerogatives?

1028