What is the SQL query describing usage of MAX aggregate function and GROUP-BY with 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.

Mandalika

Updated on: 30-Nov-2020

170 Views

Kickstart Your Career

Get certified by completing the course

Get Started