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 a buffer in memory?
Which is faster delete or truncate?
How many databases can be created inside an instance in db2 ?
Which isolation level provides maximum concurrency?
What is data manager?
can we view the access paths created by dbrm ? how ? thx
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is rct?
Which component is responsible for db2 startup and shutdown?
List out the three types of page locks that can be held.
What is db2?
What is db2 plan table?
What is the role of schema in the db2 database?
Where can you declare a cursor in a cobol-db2 program?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?