Home >> MySql >> Select Rows with max value for each group in MySql

Select Rows with max value for each group in MySql

Find a maximum value for a certain column.

Example-1

SELECT MAX(price) FROM products

Example-2

Employee Table

Name City Salary
Raj Delhi 200000
Ravi Delhi 10000
Ram Lucknow 30000
Suresh Lucknow 400000

Solution

SELECT city,MAX(salary) FROM employee GROUP BY city;

Output

City Salary

Delhi 200000

Lucknow 400000

About Coderraj

Coderraj is the global online platform and circle for programmers to learn, communicate, share their knowledge and growth their careers.

QUICK LINKS