質問編集履歴
1
誤記入
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -9,7 +9,7 @@
|
|
|
9
9
|
-----
|
|
10
10
|
select case when grouping(RALL15) = '1' then '合計' ELSE NULL END as 'ALL',
|
|
11
11
|
RALL15, SUM(RALL18) as RALL18
|
|
12
|
-
from
|
|
12
|
+
from test with(nolock)
|
|
13
13
|
group by RALL15 with ROLLUP
|
|
14
14
|
order by 'ALL', RALL15
|
|
15
15
|
|