34,838
社区成员




SELECT bumen,
SUM(one) AS 招待费, SUM(two) AS 接发车费, SUM(three) AS 差旅费, SUM(four) AS [话 费], SUM(five) AS [工 资],
SUM(six) AS 办公费 from datatable GROUP BY [bumen] with rollup order by max(xiaozu)
SELECT bumen,
SUM(one) AS 招待费, SUM(two) AS 接发车费, SUM(three) AS 差旅费, SUM(four) AS [话 费], SUM(five) AS [工 资],
SUM(six) AS 办公费 from datatable GROUP BY [bumen] with rollup order by max(xiaozu), CASE WHEN (GROUPING(bumen) = 1) THEN 1 else 0 end
SELECT bumen,
SUM(one) AS 招待费, SUM(two) AS 接发车费, SUM(three) AS 差旅费, SUM(four) AS [话 费], SUM(five) AS [工 资],
SUM(six) AS 办公费 from datatable GROUP BY [bumen] with rollup order by min(xiaozu)