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 / rama krishna reddy
Hi harish,
the query you mentioned will give diffrent result like
col1 count
---------- --------
2007-03-19 1
2007-05-19 2
2008-05-19 1
2009-05-19 2
2004-05-19 1
but the number of students joined in 2007 is 3 but is
showing in 2 diff lines in the output for ur query
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What does db2 plan contain?
How do I add a column in db2?
What's The Percentage Free Space ?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How do I copy a table in db2?
What is a storage group (stogroup)?
Is it possible using max on a char column?
When do you specify the isolation level?
How to create db2 table in mainframe?
What is a db2 schema?
Why cursor is used in db2?
What is the usage of open cursor command?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is page size in db2?
How connect db2 database to datastage?