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
- 14679 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / rama krishna reddy
Hi Amita,
i already tried with the query that you mentioned..
it will work in oracle...but it will not work in db2..
db2 doesn't allow any function like year(),month(),substr
()...in group by clause...
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are packages in db2?
How do I start db2 in windows?
What is explain plan in db2?
what is the responsibility of the construction superintendent
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is a db2 tablespace?
How many databases are there?
What are db2 objects?
What is a plan and package in db2?
What do you mean by rollback?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is a storage group (stogroup)?
What is a Foreign Key?
How to check sequence on a table in db2?
What is the role of union all and union
