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.