MySQL: How to get Max Value for each group?

In this post, I am giving you a full demonstration on finding max value for each group of records in MySQL.

Today morning, I was working on one report and requirement is to find max value records for each particular group of data.

I know, You guys are thinking that this is a very simple solution using MAX() and GROUP BY clause.
But many of database developers have always questioned about: Why we cannot add any other columns in SELECT list which are not part of aggregation or the GROUP BY clause?

Below is a one solution, you can find MAX record without using GROUP BY clause and you can also add other columns in the SELECT list.

First, Create a table with sample data:

Find max salary values for each department:

The Result:

MySQL Max Value For Each Group

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz