What is the difference between IN subselects and EXISTS
subselect?
- 1 Answers
- 9908 Views
- HCL, PreVator, TCS, I also Faced
- E-Mail Answers
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 difference between alias and synonym in db2?
What is a db2 table?
Explain in brief how does db2 determine what lock-size to use?
What is runstats and reorg in db2?
What parameters are used to control the free space in DB2?
How many types of page locks can be held in db2?
what is the sqlcode -501
How to compare data between two tables in db2?
What are host variables in db2?
What are the contents of a dclmgen?
What is a db2 schema?
What are the two types of logging in the db2 database? Explain them.
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is bind package and plan in db2?
Is schema the same as database?
