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 |
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
What is null indicator in cobol db2?
What are host variables in db2?
What is the use of reorg in db2?
What is bind package and plan in db2?
What is the difference between Primary key and unique index?
what is dynamic cursor?gives syntax for this?
What is a synonym ?
What is package versioning? Please give an example.
What is a bind in db2?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is a system catalog table in db2?