What is the difference between using bind () and rebind () methods of naming class?
No Answer is Posted For this Question
Be the First to Post Answer
What is deadlock?
How to resolve deadlock issue
How do I add a column to a table in db2?
What is DYNSLT keyword? How do you perform selection using DYNSLT
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
Is it possible to precompile if db2 goes down?
Explain the EXPLAIN statement?
How do you do the EXPLAIN of a dynamic SQL statement?
How is the value function used?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
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