Get max value in a database field

[willcycle]

How would I get the maximum value of a particular field in a Joomla database? I have an 'assetid' database column that is not automatically incremented and I would like to use Joomla Query to find the highest value in the table.

[sudo-web]

I assume you have some coding knowledge if you ask that question.
The best way is to use the Joomla Methods for that:

https://docs.joomla.org/Selecting_data_using_JDatabase

Code: Select all

$query
    ->select('MAX('.$db->quoteName('assetid').')')
    ->from($db->quoteName('#__table'));

If you need help with it just ask.

[willcycle]

Thanks. Works fine