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
14682 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

List some fields from sqlca?

1107

How to access db2 tables in mainframe?

1103

What is the maximum No of rows per page?

1116

What is the latest version of ibm db2?

1338

Mention the different locking levels that are available in db2.

1186

Is db2 relational database?

1045

What is dbrm? What it contains?

1217

What is the role of data manager in the db2 database?

1158

How to rename a table in DB2 ?

1146

What is load utility in db2?

1230

What does db2 mean?

1085

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1143

What are the rules for db2 programming?

1154

What is null indicator in cobol db2?

1111

What are types of indexes?

1189