What is the difference between IN subselects and EXISTS
subselect?
Answer Posted / 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 |
Post New Answer View All Answers
What is check constraint in db2?
What is buffer pool and list some of them?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is load utility in db2?
What is explain plan in db2?
What is drop table?
What is the syntax for FETCH in DB2 ?
Where do you specify them?
What is bufferpool in db2?
What are the uses of db2 optimizer?
What does db2 blu stand for?
What is a db2 table?
How do I import a csv file into db2?
Which isolation level provides highest data integrity?
Explain about cursor stability?