mysql group by 后 取最大记录

SELECT * FROM 
(SELECT pool.`name`, s.* FROM fa_stock s LEFT JOIN fa_pool pool ON pool.id = s.pool_id WHERE s.id IN (123) ORDER BY s.id DESC LIMIT 10000) a 
GROUP BY a.pool_id