Use the TALLY command to count the occurrence of identical values in a column.
Options
colname
Specifies the name of the column from which you want to tally information.
FROM tblview
Specifies the table or view.
WHERE clause
Limits rows of data. For more information, see the "WHERE" entry.
About the TALLY Command
The TALLY command displays each value and its number of occurrences as a list.
You can also count identical values by choosing Calculate: Tally from the Data Browser.
TALLY does not work with a NOTE data type.
To display data without column headings, set HEADINGS off before using the TALLY command. Setting HEADINGS off is useful if you direct output of the TALLY command to a device (printer or file) other than the screen, for example, to a file that you intend to load into another database. The default setting for HEADINGS is on.
Example
The following command lists occurrences of each customer identification number in the transmaster table. R:BASE sorts the information in ascending order by custid.
TALLY custid FROM transmaster
