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
- 9 Answers
- 11346 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
Discuss about db2 bind?
What is the latest version of ibm db2?
What is db2?
How can deadlocks be resolved?
How do I add a column to an existing table in db2?
What are the contents of a dclmgen?
What is the use of predicate?
What is database manager in db2?
What are db2 objects?
How to check table size in db2 sap?
what is utility for parm lib
Explain packages.
Is db2 a mainframe?
How connect db2 database to datastage?
What is data manager?
