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 is the physical storage length of the data types: date, time, timestamp in the db2 database?
Explain about dbrm.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is an instance database?
How to fetch the last row from the table in SQL (db2)?
What is ibm db2 connect?
What is dbrm in db2 database?
what is db2 restart?
What is check constraint. Explain with example.
What are the 2 sqlcodes that are returned?
Define buffer pool.
What is db2 bind?
What is difference between rollback and commit?
How is deadlock resolved?
What db2 400?