SQL Query for MAX Function with GROUP BY and HAVING

We can find the highest ORDER_TOTAL datewise from the ORDERS DB2 table using below query.

Example

SELECT ORDER_DATE, MAX(ORDER_TOTAL) FROM ORDERS
GROUP BY ORDER_DATE

We will use ‘GROUP BY’ on ORDER_DATE to group the result date wise and MAX aggregate function will help us to get the maximum ORDER_TOTAL placed at that particular date.

For example, if we have below ORDERS DB2 table.

Then the SQL query - SELECT ORDER_DATE, MAX(ORDER_TOTAL) FROM ORDERS GROUP BY ORDER_DATE will return the result below.