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
- 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
What is the physical storage length of timestamp data type?
What does a deadlock mean in DB2?
What is a cursor in programming?
What type of database is db2?
What is the function of logging in the db2 database?
Explain package in db2 and its advantages?
How can you find out the # of rows updated after an update statement?
What is null in db2?
What is dbrm? What it contains? When it will be created?
Explain various types of locks in db2?
What is db2?
What is meant by union and union all?
What types of tables are there in the db2 database?
Why do we need reorg in db2?
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 ?...
