mysql根据租赁记录统计排名前5的摊位 已知表为租赁记录表,如下图 前端效果页面如下 sql如下: SELECT stall_id, COUNT(stall_id) as stall_count FROM t_rent GROUP BY stall_id ORDER BY COUNT(stall_id) DESC vo如下 controller如下 service serviceImpl mapper xml