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
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
What is collection in db2 bind?
How can record locking be achieved in those DB2 versions which do not support it?
What is the difference between bind and rebind in db2?
How many databases can be created inside an instance in db2 ?
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 do you mean by between and in? Is between inclusive of specified range values?
Mention some fields that are a part of sqlca.
What is a db2 tablespace?
What is the use of db2 optimizer?
Which components manage deadlocks in db2?
How to fetch the last row from the table in SQL (db2)?
What is the use of runstats in db2?
Mention the location where the output received from explain statement is stored.
What is a system catalog table in db2?
What is a page in db2?