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 concurrency issues?
Which command is used to connect to a database in DB2 ? Give the Syntax.
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Define predicate?
Mention the location where the output received from explain statement is stored.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
Can you tell me how can you find out the # of rows updated after an update statement?
What is the maximum length of sqlca?
What is schema in db2?
What is dbrm library?
What is table space in db2?
Which command is used to remove all rows from a table?
What is a db2 tablespace?
What is the max length of sqlca?
What do you mean by storage group (stogroup)?