Hi Amita, i already tried with the query that you mentioned.. it w

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

Question Posted / rama krishna reddy

9 Answers
14309 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

Please Help Members By Posting Answers For Below Questions

What is the physical storage length of timestamp data type?

1101

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3218

How is deadlock resolved?

1152

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1187

How to check last update on table in db2?

1061

Are views updateable?

1165

What is a trigger in the db2 database?

1089

Mention the definition of cobol in varchar field.

1250

What is db2 stogroup?

1164

What is ibm db2 connect?

1002

What are the 2 sqlcodes that are returned?

1196

What is explain in db2?

1033

Explain in brief how does db2 determine what lock-size to use?

1046

How do you concatenate the firstname and lastname from emp table to give a complete name?

1077

Which are the db2 tools to protect integrity of the database?

1124