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 to find the number of rows in db2 tables?
What is DCLGEN ?
What is a lock?
What's The Error Code For Unique Index Voilation?
What is the role of data manager in the db2 database?
What will the DB2 optimizer do?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
can we update the table by using cursors can anyone post the query?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'
What is declare cursor?
How many databases are there?