출처1 : <a href="http://kokun.tistory.com/entry/MSSQL-ROLLUP-GROUPINGID-CUBE-%ED%95%A8%EC%88%98" target="_blank" class="tx-link">http://kokun.tistory.com/entry/MSSQL-ROLLUP-GROUPINGID-CUBE-%ED%95%A8%EC%88%98</a> 아래 방법으로 토탈 및 서브토탈 등을 구할 수 있다.&nbsp; 하지만 rollup한 테이블에 정보를 다시 보여주려면 key로 조인하여야 하는데,&nbsp; 조인을 하는 동안 순서가 엉크러져버리는 경우가 있었다. 해서 아래와 같은 방법으로 order by 절을 구성하여 null을 맨 아래로 내리면서 sort 할 수 있었다. <div class="txc-textbox" style="border-style: solid; border-width: 1px; border-color: rgb(254, 254, 184); background-color: rgb(254, 254, 184); padding: 10px;"> 

SELECT&nbsp;*

FROM #TMP

ORDER BY


&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CASE WHEN
RGF IS NULL THEN 1 ELSE 0 END, RGF, 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CASE WHEN
RFULL_PATH_NAME IS NULL
THEN 1 ELSE 0 END, RFULL_PATH_NAME,

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CASE WHEN
EQUIP_ID IS NULL
THEN 1 ELSE 0 END, EQUIP_ID

&nbsp;

 </div> <p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; "><img src='/api/file/11EB0D04F5740E1297400242AC110002' style = 'max-width:100%;height:auto;' /><p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; float: none; clear: none;"> <p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; ">&nbsp;<p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; ">&nbsp;<p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; ">&nbsp;<p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; "><img src='/api/file/11EB0D04F578A64197400242AC110002' style = 'max-width:100%;height:auto;' /><p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; float: none; clear: none;"> <p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; "><img src='/api/file/11EB0D04F57CDF9C97400242AC110002' style = 'max-width:100%;height:auto;' /><p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; float: none; clear: none;"> <p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; "><img src='/api/file/11EB0D04F580D84697400242AC110002' style = 'max-width:100%;height:auto;' /><p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; float: none; clear: none;"> <p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; "><img src='/api/file/11EB0D04F583ACA597400242AC110002' style = 'max-width:100%;height:auto;' /><p style="box-sizing: border-box; word-break: break-word; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; float: none; clear: none;"> <br style="box-sizing: border-box; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; "><br style="box-sizing: border-box; color: rgb(51, 51, 51); font-family: NanumBarunGothic, &quot;맑은 고딕&quot;, &quot;malgun gothic&quot;, AppleGothicNeoSD, &quot;Apple SD 산돌고딕 Neo&quot;, &quot;Microsoft NeoGothic&quot;, &quot;Droid sans&quot;, sans-serif; font-size: 14px; ">

통계를 위한 group by rollup 서브토탈, 토탈