Sql Max() frunction is an aggregate function that returns the highest value of an expression, to get the maximum value in your statement use this function.
Example:1
Select MAX(sal)
from emp;
Example:2
Select Max(sales_order_date)
from sales_order
Example:1
Select MAX(sal)
from emp;
Example:2
Select Max(sales_order_date)
from sales_order