Returning the max of a column Table:

SubSection | TradingId  | Year  | Amount
100A           5001       2004  -120
200B           5001       2005  -130
300C           5002       2006  -140
300C           5003       2007  -150


I want to return the MAX Trading Id based on the subsection, I want this:

SubSection | TradingId  | Year  | Amount
100A           5001       2004  -120
200B           5001       2005  -130
300C           5003       2007  -150


I tried selecting MAX with a GROUPBY Subsection, tried HAVING MAX etc but no luck
SELECT t1.*
FROM the_table t1
WHERE t1.trading_id = (SELECT max(t2.trading_id)
                    FROM the_table t2
                    WHERE t2.subsection = t1.subsection)