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 ...
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.
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 ...
Latest Answer : for both -911 or -913 , you can check further SQLERRD(3) also contains the reason-code which indicates whether a deadlock or timeout occurred. The most common reason codes are: ...
Latest Answer : sysibm is a default schema which has all the base tables and syscat is also a default schema which has the tables and views of sysibm objects... ...