SQL Query Multiple Columns Using Distinct on One Column Only

Solution

select ID, Category from t_Con_ChargesAmount where
 ID in (Select max(ID) FROM t_Con_ChargesAmount group by Category)

This query will select ID and Category from the table and the Category will be distinct now.