Hi, I hope this query will work ... u didnt understand the REK,they g

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 / harish

9 Answers
14308 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / harish

Hi,

I hope this query will work ...

u didnt understand the REK,they gave only output format
column names cannot be changed.....

select substr(DOJ,(1,4)),count(*) from emp_tbl
group by DOJ

let me know if i am wrong

HARISH POOMGAME SHIVAPPA
NIIT TECH
KOLKATA

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is page size in db2?

979

What is load utility in db2?

1181

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3581

Are views updateable?

1165

How do I copy a table in db2?

1003

What is bufferpool in db2?

1059

Explain the benefits you can get from mainframe connect?

974

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104

What is cobol db2?

1003

Can there be more than one cursor open for any program?

1170

What is blu acceleration in db2?

1074

What is release/acquire in bind?

1109

what is utility for parm lib

2380

List some fields from sqlca?

1061

What is drop table?

1017