limit keyword in sql minimum and max code example
Example 1: sql display max value
SELECT MAX(<numeric column>) FROM <table>;
SELECT MAX(<numeric column>) FROM <table> GROUP BY <other column>;
Example 2: SQL get max per id
select name, max(value)
from out_pumptable
group by name