How do I add a column to an existing table in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is the maximum size of varchar data type in db2?
Explain various types of locks in db2?
What is UNION,UNION ALL?
The only place of VSAM KSDS in DB2 is?
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
How do I optimize a query in db2?
What is the logical entity between plan and Package?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
How many databases are there?
Which catalog table stores referential constraints?
What is DCLGEN ?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th