Filter
Top Products
[Table: Data type for results of dyadic operators]
2.2.2 Obtaining total, average, maximum, and minimum value, and row count
for column values
So far, this manual has only explained the fetching of data from required columns for one specified row from a table.
The single row SELECT statement can be used to fetch the results of totaling data from multiple rows. By totaling the
data, the total, average, maximum, and minimum values, and the row count for the data can be calculated. This is
achieved by specifying a set function in the select column list. The following is an example of specifying a set function:
Example 1:
In this example, the total of ORDERQTY is fetched from the ORDER table.
16