What is the difference between IN subselects and EXISTS
subselect?
Answer / s
IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
true value.
| Is This Answer Correct ? | 11 Yes | 2 No |
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is the difference between oracle and db2?
What is view db2?
What are common abends
can we drop column from a table
What is a thread?
What is the difference between dbm cfg and db cfg file in db2 ?
How is a typical DB2 batch program executed ?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What are the isolation levels possible ?
what is dynamic cursor?gives syntax for this?