Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14322 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
What is the syntax for FETCH in DB2 ?
How can the duplicate values be eliminated from db2 select?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What are the 2 sqlcodes that are returned?
What are the various isolation levels possible?
What is the difference between bind and rebind in db2?
What is db2 bind?
What is runstats db2?
Can one database have multiple instances?
Is db2 a programming language?
How do you stop a db2 database in linux?
Why select is not preferred in embedded sql programs?
What is null indicator in db2?
What is performance tuning db2?
