摘要：表结构如下图,找出productid列中出现次数最多的productid，语句为：select top 1 count( productid) as mycount,productid from dbo.CatalogsProducts group by productid order by mycount desc如果要找出出现次数大于7的；应该为：select top 10 count( pr... 阅读全文