<![CDATA[
<p><span style="color: #800000;">1. 롤업</span></p><p><span style="color: #800000;">SELECT</span> <span style="color: #000080;">nvl</span>(<span style="color: #006464;">job</span>, <span style="color: #008000;">'토탈값'</span>) <span style="color: #800000;">AS</span> <span style="color: #006464;">job</span>,</p><p><span style="color: #000080;">sum</span>(<span style="color: #000080;">decode</span>(<span style="color: #006464;">deptno</span>, <span style="color: #0000ff;">10</span>, <span style="color: #006464;">sal</span>, <span style="color: #800000;">null</span>)) <span style="color: #800000;">AS</span> <span style="color: #006464;">"10"</span>,</p><p><span style="color: #000080;">sum</span>(<span style="color: #000080;">decode</span>(<span style="color: #006464;">deptno</span>, <span style="color: #0000ff;">20</span>, <span style="color: #006464;">sal</span>, <span style="color: #800000;">null</span>)) <span style="color: #800000;">AS</span> <span style="color: #006464;">"20"</span>,</p><p><span style="color: #000080;">sum</span>(<span style="color: #000080;">decode</span>(<span style="color: #006464;">deptno</span>, <span style="color: #0000ff;">30</span>, <span style="color: #006464;">sal</span>, <span style="color: #800000;">null</span>)) <span style="color: #800000;">AS</span> <span style="color: #006464;">"30"</span>,</p><p><span style="color: #000080;">sum</span>(<span style="color: #006464;">sal</span>) <span style="color: #800000;">AS</span> <span style="color: #006464;">"토탈값"</span> <span style="color: #800000;">FROM</span> <span style="color: #8e00c6;">emp</span></p><p><span style="color: #800000;">GROUP</span> <span style="color: #800000;">BY</span> <span style="color: #800000;">ROLLUP</span>(<span style="color: #006464;">job</span>) <span style="color: #800000;">ORDER</span> <span style="color: #800000;">BY</span> <span style="color: #006464;">job</span> <span style="color: #800000;">ASC</span><span style="color: #ff0000;">;</span></p><p> </p><p>2. 그룹핑셋</p><p><span style="color: #800000;">SELECT</span> <span style="color: #000080;">nvl</span>(<span style="color: #006464;">job</span>, <span style="color: #008000;">'토탈값'</span>) <span style="color: #800000;">AS</span> <span style="color: #006464;">job</span>, <span style="color: #000080;">sum</span>(<span style="color: #000080;">decode</span>(<span style="color: #006464;">deptno</span>, <span style="color: #0000ff;">10</span>, <span style="color: #006464;">sal</span>, <span style="color: #800000;">null</span>)) <span style="color: #800000;">AS</span> <span style="color: #006464;">"10"</span>,</p><p><span style="color: #000080;">sum</span>(<span style="color: #000080;">decode</span>(<span style="color: #006464;">deptno</span>, <span style="color: #0000ff;">20</span>, <span style="color: #006464;">sal</span>, <span style="color: #800000;">null</span>)) <span style="color: #800000;">AS</span> <span style="color: #006464;">"20"</span>,</p><p><span style="color: #000080;">sum</span>(<span style="color: #000080;">decode</span>(<span style="color: #006464;">deptno</span>, <span style="color: #0000ff;">30</span>, <span style="color: #006464;">sal</span>, <span style="color: #800000;">null</span>)) <span style="color: #800000;">AS</span> <span style="color: #006464;">"30"</span>,</p><p><span style="color: #000080;">sum</span>(<span style="color: #006464;">sal</span>) <span style="color: #800000;">AS</span> <span style="color: #006464;">"토탈값"</span> <span style="color: #800000;">FROM</span> <span style="color: #8e00c6;">emp</span></p><p><span style="color: #800000;">GROUP</span> <span style="color: #800000;">BY</span> <span style="color: #800000;">GROUPING</span> <span style="color: #800000;">SETS</span> ( (<span style="color: #006464;">job</span>), () ) <span style="color: #800000;">ORDER</span> <span style="color: #800000;">BY</span> <span style="color: #006464;">job</span> <span style="color: #800000;">ASC</span><span style="color: #ff0000;">;</span></p><p> </p><div class="figure-img" data-ke-type="image" data-ke-style="alignCenter" data-ke-mobilestyle="widthOrigin"><img src="https://t1.daumcdn.net/cafeattach/zchT/348b6d793394a87464b2a213559bd6259643fae3" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/348b6d793394a87464b2a213559bd6259643fae3" data-origin-width="455" data-origin-height="149"></div>
<!-- -->
]]>
카페 게시글
1. SQL 수업 780문제
Re: 문제197. (오늘의 마지막 문제) 삼성 디스 플레이스에 자주 작성하는 SQL의 예
다음검색
