SELECT - result
The data in
result defines whether the resulting set consists of multiple rows (table-like structure) or a single row (
flat structure). It
specifies the columns to be read and defines their names in the resulting set. Note that column names from the database table can be changed. For single columns,
aggregate expressions can be used to specify
aggregates. Identical rows in the resulting set can be excluded, and individual rows can be protected from parallel changes by another program.