|
||
0
0
¾Æ¸§´Ù¿î´ñ±Û
decode ¸¦ÀÌ¿ëÇÑ pivotÀ¸·Î °¡´ÉÇÒ°Í°°¾Æ¿ä
2016-05-29
|
0
0
zeal123
´äº¯ °¨»çÇÕ´Ï´Ù
2016-05-29
|
0
0
û»ê°¡¸®Åõ¼¦
°£´ÜÇÏ°Ô ÇÏ¸é ¾Æ·¡¿Í °°ÀÌ..
select no, decode(»óÇ°, \'A\', »óÇ°) AS \"A»óÇ°\", decode(»óÇ°, \'B\', »óÇ°) AS \"B»óÇ°\",, ³ª¸ÓÁö from dual. °íÀ¯°ª ±âÁØÀ¸·Î group by´Â ÇØÁֽñ¸¿ä |
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | ¸ñ·Ïº¸±â |