SQL Reference
If neither GROUP BY nor HAVING is used:
- Either the select list must not include any column functions, or each
column-name in the select list must be specified within a column
function or must be a correlated column reference.
- If the select does not include column functions, then the select list is
applied to each row of R and the result contains as many rows as there are
rows in R.
- If the select list is a list of column functions, then R is the source of
the arguments of the functions and the result of applying the select list is
one row.
In either case the nth column of the result contains the values
specified by applying the nth expression in the operational form of
the select list.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]