<div>Day | H | M | Val<br></div> <div>_________________________</div> <div>20150430 |<span class="Apple-tab-span" style="white-space:pre;"> </span>00<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">05</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">16.8</span></div> <div>20150430 <span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span>05<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">16</span></div> <div>20150430<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span>05<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">13.8</span></div> <div>20150430<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span>05<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">15</span></div> <div>20150430<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span>05<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">17.7</span></div> <div>20150430<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span>05<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">17.4</span></div> <div>20150430<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">10</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">17</span></div> <div>20150430<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span>10<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">17.6</span></div> <div>20150430<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span>10<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">17.9</span></div> <div>20150430<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">00</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span>10<span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|</span><span class="Apple-tab-span" style="font-size:9pt;line-height:1.5;white-space:pre;"> </span><span style="font-size:9pt;line-height:1.5;">17.8</span></div> <div><span style="font-size:9pt;line-height:1.5;"><br></span></div> <div><span style="font-size:9pt;line-height:1.5;"> :</span></div> <div><span style="font-size:9pt;line-height:1.5;">20150525</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|23</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|55</span><span style="font-size:9pt;line-height:1.5;"> </span><span style="font-size:9pt;line-height:1.5;">|18.8</span></div> <div><span style="font-size:9pt;line-height:1.5;">____________________________</span></div> <div><span style="font-size:9pt;line-height:1.5;"><br></span></div> <div>위와 같은 데이터를 일자 및 시간 단위 평균을 구한뒤 행/열을 바꾸려고 합니다.</div> <div>예) </div> <div> <div>Day | H | 05 | 10 | ..... | 00 | </div> <div>______________________________________________</div> <div>20150430 | 00 | 18.3 | 16.3 | ...... | 15.3 |</div></div> <div><br></div> <div>그래서 PIVOT을 아래와 같이 지정을 했습니다.</div> <div><br></div> <div> <div>PIVOT(</div> <div> avg(Val) -- max()로 지정한 이유는 Day와 H에 해당하는 </div> <div> FOR MN IN ('05','10','15','20','25','30','35','40','45','50','55','00')</div> <div>) ORDER BY DAY, H, M;</div></div> <div><br></div> <div>그런데 PIOVT을 사용하니 '05' 열과 '00'열의 값이 null로 결과가 출력되는데 </div> <div><br></div> <div>무슨 문제가 있는 것일까요? ㅜㅜ</div> <div><br></div> <div>error라고 출력해주면 좋을텐데.... ㅜㅜ</div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.