Describe the elements of the SELECT query syntax. SELECT element FROM table WHERE conditional statement?
Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.
Joins, unions and nested selects are used to retrieve data.
Latest Answer : The two tables has to be linked.EXEC SQL
SELECT A.EMP_ID, B.WAGE FROM Table1 A, Table2 B WHERE A.EMP_ID = B.EMP_ID
AND A.EMP_ID = ...
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 ...
The explain statement provides information about the optimizer's choice of access path of the sql.
Latest Answer : The EXPLAIN statement obtains information about access path selection for an explainable statement. A statement is explainable if it is a SELECT or INSERT statement, or the searched form of an UPDATE or DELETE statement.The information obtained is placed ...
An embedded sql statement may return a number of rows while the programming language can only access one row at a time. The programming device called a cursor controls the position of the row.
Latest Answer : hi friends, In DB2 actually we use CURSOR when there are more than one row to be fetched in a SELECT statement. ...
The two parameters used in the CREATE statement are the PCTFREE which specifies the percentage of free space for each page and FREEPAGE which indicates the number of pages to be loaded with data between
A LIKE table is created by using the LIKE parameter in a CREATE table statement. LIKE tables are typically created for a test environment from the production environment.
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Never. Such processing could produce duplicate values violating entity integrity. Primary keys must be updated one at a time.
DB2 use the multiple indexes to satisfy multiple predicates in a SELECT statement that are joined by an AND or OR.
