What do you mean by between and in? Is between inclusive of specified range values?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What is host variable?
how can we find nth max salary from A table
What is universal database?
What is dbrm in db2 database?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is dclgen (declaration generator)?
List down the data types in the db2 database.
wht is d/f between union and joins ?
What does an outer join do?
What are the various locks available?