日期:2014-05-18 浏览次数:20437 次
SELECT F1,COUNT(F1) FROM FIXEDASSET GROUP BY F1 ORDER BY (COUNT(F1)) DESC
SELECT F1,COUNT(F1) FROM (select top 200 * from fixedasset order by id) t --以id升序排序取前200 GROUP BY F1 ORDER BY (COUNT(F1)) DESC