Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 14321 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain what are the various isolation levels possible?
What is the difference between nvl and coalesce?
What types of tables are there in the db2 database?
What is cursor in dbms?
What is the maximum No of rows per page?
What is the purpose of rollback and commit?
What is a page in db2?
What is cobol db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is rebind in db2?
What is db2 optimizer?
What is the maximum size of a char data type in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is precompiler in db2?
What is release/acquire in bind?
