Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN subselects and EXISTS
subselect?
- 1 Answers
- 11082 Views
- HCL, PreVator, TCS, I also Faced
- E-Mail Answers
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 |
What is a buffer in memory?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
what is the use of bind parameter, Replace?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
Highlight all the advantages that are attached to a package.
Mention the different locking levels that are available in db2.
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
what is the sqlcode -501
What is the syntax for creating a table in the db2 database?
Explain about rct in db2?
What is the meaning of -805 SQL return code?
Explain correlated sub-queries.
COBOL 
