Re: Max values in db

[Will Leshner <leshner at ljug dot com>]

Ron Lambert wrote:

> Is there a way to find the max value of a field set?  I have been 
> considering the SQL(...) method, but I cannot come up with a wording.
If your SQL engine supports the max() function, you can just use that:

SELECT max(column_name) FROM table_name;

--
REALbasic database options: http://sqlabs.net
REALbasic news and tips: http://rbgazette.com
KidzLog & KidzMail: http://haranbanjo.com
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>