SELECT * FROM assets ,category WHERE 1=1 and save_number > (SELECT COUNT(assets.category_no) AS SL FROM assets GROUP BY assets.category_no)GROUP BY category.category_no DESC limit 0,1000
报错[Err] 1242 - Subquery returns more than 1 row
两个字段比大小 第二个是算出来的