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
- 14248 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / harish
Hi,
I hope this query will work ...
u didnt understand the REK,they gave only output format
column names cannot be changed.....
select substr(DOJ,(1,4)),count(*) from emp_tbl
group by DOJ
let me know if i am wrong
HARISH POOMGAME SHIVAPPA
NIIT TECH
KOLKATA
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How can we retrieve the total number of records in RPG & CLLE?
Define data page.
What is view db2?
What is dclgen in db2?
Why do chiropractors use drop table?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is copy pending and check pending in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What is db2 command?
How to find schema of a table in db2?
What is db2 stogroup?
Where can you declare a cursor in a cobol-db2 program?
Explain the function done by data manager?
Which command is used to remove all rows from a table?
What is the information associated with sysibm.syslinks table?
