sql - Getting the maximum value of balances from different employee ids -

sql - Getting the maximum value of balances from different employee ids -

i have problem in using select statement want select maximum balances per employee id. have table this.

employe id | balances c50-5050 | 100 c50-5050 | 200 **c50-5050 | 300** c50-5051 | 200 **c50-5051 | 300**

the 1 asterisk indicates want select table.

i need show in datagrid view in vb.net. have thought on how this?

use below query

select max(balances),employe_id table grouping employe_id

sql sql-server sql-server-2008