Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between IN subselects and EXISTS
subselect?
- 1 Answers
- 10981 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 parameters are used to control the free space in DB2?
How to create backup table in db2?
Is db2 a programming language?
How can you split a table in to exactly half?
Explain correlated sub-queries.
Define sqlca.
what is a plan and how do you refer the plan in the program?
how can u understand the end of the table ?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
How to access db2 tables in mainframe?
Once you create a view, where would information about the view be stored?
COBOL 
