MSSQL - Group by with Max

 

 Watch this example on YouTube

1. Table

ID    Name    Amount
1    Jan    20
2    Jan    30
3    Feb    10

2. Query

select Name, Max(Amount)
From Table_1
Group by Name