 Related Questions A subselect is a select which works in conjunction with another select. A nested select is a kind of subselect where the inner select passes to the where criteria for the outer select. Group by controls the presentation of the rows, order by controls the presentation of the columns for the results of the SELECT statement. Latest Answer : Group By forms Groups (of course), but this means it also SORTS; but it will also retrieve a DISTINCT RECORD SETORDER BY Sorts by the columns included in the Statement, and does not retrieve DISTINCT Records.Neither determines the order of the columns ... What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made? Static sql is hard-coded in a program when the programmer knows the statements to be executed. For dynamic sql the program must dynamically allocate memory to receive the query results. Compare a subselect to a join. Any subselect can be rewritten as a join, but not vice versa. Joins are usually more efficient as join rows can be returned immediately, subselects require a temporary work area for inner selects results while processing the outer select. If there is an index on the attributes tested an IN is more efficient since DB2 uses the index for the IN. (IN for index is the mnemonic). Latest Answer : hi vipin sharma,IN subselects can also uesd in corelated sub queries.IN subselects needs to specify the vlues u want to search.EXISTS subselects doesn't need any to specify values . it searches ... Latest Answer : The Checkpening is referential integrity is in doubt or its check constraints are violated. To remove need to run CHECK data utility.Copy pending - LOAD places a table space in the copy pending status. to remove need to take the backup on a table ... Latest Answer : DIFFERENCE BETWEEN SPUFI AND QMF : SPUFI : 1.you can execute more queries at a time. 2. In SPUFI result of the query will be in PS or in PDS member will store but3.you know the sqlcode after executing the query. QMF: 1.you cannot execute more than ... Latest Answer : hi folks,collection: set of packages with a collection idversion: it refers to a package created at a particular time.(ie) if the same package is created at a later time with no changes it will be a different version. there are two options for version ... Latest Answer : DIFFERENCE BETWEEN DYNAMIC(interactive) and STATIC(embedded) SQL :The difference is the time at which the BIND occurs.In static mode, the bind is done prior to the execution and is stored in a PLAN. In dynamic mode, the BIND occurs at execution time.This ... Read Answers (1) | Asked by : krishna
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
