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

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

1288

Which is faster delete or truncate?

1175

How to execute stored procedures?

1175

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1138

What is precompiler in db2?

1075

What is dpf in db2?

1167

What does reorg do in db2?

1074

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

1110

What is page size in db2?

1023

What is a trigger in the db2 database?

1140

What does db2 mean?

1082

What is a dbrm in db2?

1076

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1213

What is the purpose of rollback and commit?

1278

What does sqlcabc has?

1098