<table border="1" cellpadding="1" cellspacing="1" style="margin:0px;padding:0px;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:14px;color:#000000;border-collapse:collapse;border-spacing:0px;line-height:14pt;list-style:none;width:500px;"><tbody style="margin:0px;padding:0px;"><tr style="margin:0px;padding:0px;line-height:14pt;list-style:none;"><td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">Division</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">Name</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">Value</td></tr><tr style="margin:0px;padding:0px;line-height:14pt;list-style:none;"><td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">a</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">0-abc</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">null</td></tr><tr style="margin:0px;padding:0px;line-height:14pt;list-style:none;"><td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">b</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">0-bcd</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">null</td></tr><tr style="margin:0px;padding:0px;line-height:14pt;list-style:none;"><td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">a</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">1-fgh</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">null</td></tr></tbody></table><p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;"> </p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;">테이블은 위와 같습니다.</p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;"> </p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;">Division = 'a' 일때, Name의 앞자리 값인 0 또는 1을 Value에 넣으려고 합니다.</p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;"> </p> <table border="1" cellpadding="1" cellspacing="1" style="margin:0px;padding:0px;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;font-size:14px;color:#000000;border-collapse:collapse;border-spacing:0px;line-height:20.7999992370605px;list-style:none;width:500px;"><tbody style="margin:0px;padding:0px;"><tr style="margin:0px;padding:0px;line-height:14pt;list-style:none;"><td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">Division</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">Name</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">Value</td></tr><tr style="margin:0px;padding:0px;line-height:14pt;list-style:none;"><td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">a</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">0-abc</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">0</td></tr><tr style="margin:0px;padding:0px;line-height:14pt;list-style:none;"><td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">b</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">0-bcd</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">Null</td></tr><tr style="margin:0px;padding:0px;line-height:14pt;list-style:none;"><td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">a</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">1-fgh</td> <td style="margin:0px;padding:0px;line-height:14pt;list-style:none;">1</td></tr></tbody></table><p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;"> </p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;">최종 결과는 위와 같이 나오게 하려고 하는데.. <span style="margin:0px;padding:0px;line-height:1.6;">잘안되네요..ㅋㅋㅋㅋ</span></p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;"> </p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;">제가 짠 Query는</p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;">UPDATE Table_Name</p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;">SET Value =</p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;"> ( select SUBSTR( Name, 1, 1 ) from Table_Name Where Division = 'a)</p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;">Where DIVISION = 'a'</p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;"> </p> <p style="margin:10px 0px;padding:2px 7px;font-size:14px;line-height:14pt;list-style:none;text-indent:1em;font-family:'나눔고딕', NanumGothic, '돋움', Dotum;">이건데.. 어떻게 수정해야 할까요..?</p>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.