<![CDATA[
<p><span style="color: #569cd6;">select</span></p><p><span style="color: #cccccc;">   </span><span style="color: #569cd6;">job</span><span style="color: #cccccc;">,</span></p><p><span style="color: #cccccc;">   </span><span style="color: #dcdcaa;">to_char</span><span style="color: #cccccc;">(</span></p><p><span style="color: #cccccc;">      </span><span style="color: #9cdcfe;">hiredate</span><span style="color: #cccccc;">,</span></p><p><span style="color: #cccccc;">      </span><span style="color: #ce9178;">'YYYY'</span></p><p><span style="color: #cccccc;">   ),</span></p><p><span style="color: #cccccc;">       </span><span style="color: #dcdcaa;">sum</span><span style="color: #cccccc;">(</span><span style="color: #9cdcfe;">sal</span><span style="color: #cccccc;">) </span><span style="color: #ce9178;">"토탈월급"</span></p><p><span style="color: #cccccc;">  </span><span style="color: #569cd6;">from</span> <span style="color: #9cdcfe;">emp</span></p><p><span style="color: #cccccc;"> </span><span style="color: #569cd6;">group</span> <span style="color: #569cd6;">by</span> <span style="color: #dcdcaa;">grouping</span> <span style="color: #9cdcfe;">sets</span><span style="color: #cccccc;"> ( ( </span><span style="color: #569cd6;">job</span><span style="color: #cccccc;"> ),</span></p><p><span style="color: #cccccc;">                          ( </span><span style="color: #dcdcaa;">to_char</span><span style="color: #cccccc;">(</span></p><p><span style="color: #cccccc;">                             </span><span style="color: #9cdcfe;">hiredate</span><span style="color: #cccccc;">,</span></p><p><span style="color: #cccccc;">                             </span><span style="color: #ce9178;">'YYYY'</span></p><p><span style="color: #cccccc;">                          ) ) );</span></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/4e8807926c0f43659de666151aceff9398b2e9ec" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/4e8807926c0f43659de666151aceff9398b2e9ec" data-origin-width="1005" data-origin-height="1039"></div><p><span style="color: #569cd6;">select</span> <span style="color: #dcdcaa;">decode</span><span style="color: #cccccc;">(</span></p><p><span style="color: #cccccc;">   </span><span style="color: #569cd6;">job</span><span style="color: #cccccc;">,</span></p><p><span style="color: #cccccc;">   </span><span style="color: #569cd6;">null</span><span style="color: #cccccc;">,</span></p><p><span style="color: #cccccc;">   </span><span style="color: #dcdcaa;">to_char</span><span style="color: #cccccc;">(</span></p><p><span style="color: #cccccc;">      </span><span style="color: #9cdcfe;">hiredate</span><span style="color: #cccccc;">,</span></p><p><span style="color: #cccccc;">      </span><span style="color: #ce9178;">'YYYY'</span></p><p><span style="color: #cccccc;">   ),</span></p><p><span style="color: #cccccc;">   </span><span style="color: #569cd6;">job</span></p><p><span style="color: #cccccc;">) </span><span style="color: #ce9178;">"집계컬럼"</span><span style="color: #cccccc;">,</span></p><p><span style="color: #cccccc;">       </span><span style="color: #dcdcaa;">sum</span><span style="color: #cccccc;">(</span><span style="color: #9cdcfe;">sal</span><span style="color: #cccccc;">) </span><span style="color: #ce9178;">"토탈월급"</span></p><p><span style="color: #cccccc;">  </span><span style="color: #569cd6;">from</span> <span style="color: #9cdcfe;">emp</span></p><p><span style="color: #cccccc;"> </span><span style="color: #569cd6;">group</span> <span style="color: #569cd6;">by</span> <span style="color: #dcdcaa;">grouping</span> <span style="color: #9cdcfe;">sets</span><span style="color: #cccccc;"> ( ( </span><span style="color: #569cd6;">job</span><span style="color: #cccccc;"> ),</span></p><p><span style="color: #cccccc;">                          ( </span><span style="color: #dcdcaa;">to_char</span><span style="color: #cccccc;">(</span></p><p><span style="color: #cccccc;">                             </span><span style="color: #9cdcfe;">hiredate</span><span style="color: #cccccc;">,</span></p><p><span style="color: #cccccc;">                             </span><span style="color: #ce9178;">'YYYY'</span></p><p><span style="color: #cccccc;">                          ) ) );</span></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/15bb30d7577a7c268c3f2f839f14a95a3f1e5f21" class="txc-image" data-img-src="https://t1.daumcdn.net/cafeattach/zchT/15bb30d7577a7c268c3f2f839f14a95a3f1e5f21" data-origin-width="1012" data-origin-height="1042"></div>
<!-- -->
]]>
카페 게시글
2. SQL 수업
Re: 문제7. (SQLDP문제) 위의 결과를 union all 사용하지 말고 grouping sets 를 이용해서 수행하시오
다음검색
