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
Answer Posted / raj
It should work this way also...
SELECT X.YEAR, COUNT(X.SNAME)
FROM (
SELECT SUBSTR(DOJ,1,4) AS YEAR, SNAME
FROM EMP_TBL
) X
GROUP BY X.YEAR;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What action db2 takes when a program aborts in the middle of a transaction?
How will you return the number of records in table?
What is the use of runstats in db2?
What is node in db2?
How is the value function used?
List out the three types of page locks that can be held.
Explain about cursor stability?
Explain the function done by data manager?
What is the maximum size of varchar data type in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What are the prerogatives?
How does a cursor work?
Which command is used to remove all rows from a table?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How do I optimize a query in db2?