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
13820 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 the physical storage length of timestamp data type?

1023

What does a deadlock mean in DB2?

1092

What is a cursor in programming?

1011

What type of database is db2?

908

What is the function of logging in the db2 database?

1067

Explain package in db2 and its advantages?

1133

How can you find out the # of rows updated after an update statement?

1050

What is null in db2?

947

What is dbrm? What it contains? When it will be created?

991

Explain various types of locks in db2?

1079

What is db2?

1123

What is meant by union and union all?

948

What types of tables are there in the db2 database?

1004

Why do we need reorg in db2?

919

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4213