2010年7月2日

Roll Up Demo 子类和父类求汇总
摘要： SELECT CASE WHEN (GROUPING(Item) = 1) THEN 'ALL' ELSE ISNULL(Item, 'UNKNOWN') END AS Item, CASE WHEN (GROUPING(Color) = 1) THEN 'ALL' ELSE ISNULL(Color, 'UNKNOWN') END AS Color, SUM(Quantity) AS QtySu... 阅读全文
posted @ 2010-07-02 14:15 Paul_ 阅读(123) 评论(0) 推荐(0)

导航