First Guide to SQL Anywhere Studio
PART 3. Basic SQL
This chapter describes how to construct queries that tell you aggregate information. Examples of aggregate information are as follows:
The total of all values in a column
The number of distinct entries in a column
The average value of entries in a column
A first look at aggregate functions
Using aggregate functions to obtain grouped data
Restricting groups