teratail header banner
teratail header banner
質問するログイン新規登録

質問編集履歴

1

誤記入

2015/12/19 03:02

投稿

Shimo
Shimo

スコア12

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 HLGRALLOG with(nolock)
12
+ from test with(nolock)
13
13
  group by RALL15 with ROLLUP
14
14
  order by 'ALL', RALL15
15
15