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
- 14674 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
What does db2 stand for?
Explain about rct in db2?
What is dbrm?
Is db2 a programming language?
What are types of indexes?
List down the types of triggers in the db2 database?
How to create db2 table in mainframe?
What does db2 blu stand for?
What is the latest version of ibm db2?
What is netezza database?
What is db2 instance?
How many databases are there?
How to test SQL -911 error while developing COB-DB2 program
What is bind in db2?
What is the advantage in De-normalizing tables in DB2?
