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
What are the two types of logging in the db2 database? Explain them.
Mention the location where the output received from explain statement is stored.
Define predicate?
How do I add a column in db2?
What is db2 bind?
What is consistency token in db2?
What is a db2 tablespace?
What is difference between rollback and commit?
What is a storage group (stogroup)?
What are the full forms of spufi and dclgen and why are they used?
What is bind plan?
What is iseries database?
What is bufferpool in db2?
Define check constraint.
What is db2 look?