如果您使用的是MySQLverison8,那么您可以使用 WITH 条款:
WITH counts AS (select dorm_id,count(*) as num from Dorm) select dormid, dorm_capacity,count(*) from Dorm having count(*)=(select max(num) from counts)
