求出表中哪一产品类型记录最多,快请大家帮忙了如: 产品表 id prodName prodImg prodTypeId(外键) 求出表中哪一产品类型记录最多,快请大家帮忙了[解决办法]select top 1 proID from(select count(proID) as num,proID from proType group by proID order by num desc)