We use the MAX () function to determine the largest amount or number in a column. While there may be more than one row with the largest number, only one row will be returned.

Select MAX (MonthsWithOwner) AS MostTimeWithOwner
 FROM Cat;

OUTPUT

MostTimeWithOwner
—————–
444

(1 row(s) affected)