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

Explain about mirror activator disk mirroring?

961

Explain packages.

1056

Mention the various locks that are available in db2.

976

What is schema in db2?

963

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

1056

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2340

Explain the function done by data manager?

1220

Why do we bind in db2?

1143

What is database reorganization?

1056

What is the difference between spufi and qmf?

1054

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

996

What are the various isolation levels possible?

1051

Is db2 relational database?

917

How to view db2 table structure?

962

What is the syntax for FETCH in DB2 ?

1141