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 / m4io
select A.yr, count(*) from
(select year(doj) from emp_tbl) A
group by a.yr
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is db2 a mainframe database?
Is db2 relational database?
What do you mean by storage group (stogroup)?
What is view db2?
What is a db2 table?
What is explain in db2?
What are host variables in db2?
Explain package in db2 and its advantages?
What is cobol 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
Are views updateable?
Mention the definition of cobol in varchar field.
How to check table size in db2 sap?
What is isolation level in db2?
What is the difference between nvl and coalesce?