,希望以下回答能帮助您select * from Case where CLass = (select top 1 CLass from Case group by CLass order by count(CLass ) desc)