Some aggregate functions have meaning only for certain kinds of data. For example, you can use SUM and AVG with numeric columns only.
However, you can use MIN to find the lowest value—the one closest to the beginning of the alphabet—in a character column:
SELECT MIN( Surname ) FROM Contacts;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|