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 / amita sharma
Hi,
You can write the query as below:
select year(doj) as year, count(*) as count from emp_join
group by year(doj);
Let: table name is: emp_join
For furthur clarifications or queries please ask.
Thanks;
Amita Sharma.
Output:
year count
2004 1
2007 3
2008 1
2009 2
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Is db2 a programming language?
How to find the number of rows in db2 tables?
What is db2 plan table?
How does cobol compile db2 program?
How do you eliminate duplicate values 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 is a db2 tablespace?
What is a trigger in the db2 database?
What is ibm db2 connect?
List some fields from sqlca?
Which command is used to remove all rows from a table?
What is deadlock in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is the use of with ur in db2?
What are catalog tables in db2?