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
- 14294 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vish
One way of getting the desired result is using the
VIEWS...try the given below...
CREATE VIEW EMP_YEAR
SELECT SUBSTR(DOJ(1,4) AS YOJ, SNAME FROM EMP_TBL
now select the data using this view...
SELECT YOJ, COUNT(*) FROM EMP_YEAR GROUP BY YOJ..
Note: check for the actual syntax of creating a view..what
I mentioned here is just way of donig it and not the actual
syntax.
Do let me know the output once you try it out...it should
work...enjoy!!!
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How many types of page locks can be held in db2?
What is netezza database?
Is ibm db2 open source?
What is db2 catalog database?
What are the 2 sqlcodes that are returned?
What are the different types of base tables?
What is schema in db2?
What is buffer pool and list some of them?
What is performance tuning db2?
Are views updateable?
What is a db2 schema?
What type of database is db2?
What is db2 look?
If I have a view which is a join of two or more tables, can this view be updateable?
How can we read records for specific member in CL? AND rpg?
