你可以先做极限,然后得到最大值。
SELECT max(won) FROM ( SELECT * FROM games WHERE game ='case' ORDER BY id DESC LIMIT 50 ) AS tbl