Outputs of explain are with matchcols = 0. What does this signify?
No Answer is Posted For this Question
Be the First to Post Answer
what is the difference between where clause and having clause
db2 restart logic ?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
List down the data types in the db2 database.
what is the sqlcode -501
what is a collection?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Is db2 a mainframe database?
What is DCLGEN ?
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
Explain about open switch business continuity software?