ÃÖ´ë ¼º´É ±¸ÇöÀ» À§ÇÑ È¿À²ÀûÀÎ µ¥ÀÌÅÍ ¸ðµ¨¸µ ±â¹ý
µÎ °³ÀÇ ¼Ó¼ºÀ» ³ª¿ÇÏ¿© ¹ÝÁ¤±ÔÈÇÑ °æ¿ì
°èÃþÇü µ¥ÀÌÅͺ£À̽º¸¦ ¸¹ÀÌ »ç¿ëÇß´ø °ú°Å µ¥ÀÌÅ͸𵨸µÀÇ ½À°ü¿¡ µû¶ó °ü°èÇü µ¥ÀÌÅͺ£À̽º¿¡¼µµ ÀÌ¿Í °°ÀÌ µ¥ÀÌÅ͸𵨸µÀ» ÇÑ °æ¿ì°¡ ¸¹ÀÌ ³ªÅ¸³´Ù. ´ÙÀ½ »ç·Ê¿¡¼ º¸¸é ¸ðµ¨À̶ó°í ÇÏ´Â Å×ÀÌºí¿¡´Â ¾÷¹«ÀûÀ¸·Î ÇÊ¿äÇÑ 8°³ÀÇ À妽º°¡ ÀÌ¹Ì »ý¼ºµÇ¾î ÀÖ´Â »óÅ´Ù. µ¥ÀÌÅÍ´Â 30¸¸ °ÇÀÌ°í, ¿Â¶óÀΠȯ°æÀÇ µ¥ÀÌÅͺ£À̽º¶ó°í °¡Á¤ÇÏÀÚ. À¯Çü±â´ÉºÐ·ùÄڵ忡 µû¶ó µ¥ÀÌÅ͸¦ Á¶È¸ÇÏ´Â °æ¿ì°¡ ¸¹ÀÌ ³ªÅ¸³ª À妽º¸¦ »ý¼ºÇÏ·Á°í ÇÏ´Ï ¹«·Á À¯Çü±â´ÉºÐ·ùÄÚµå °¢°¢¿¡ ´ëÇØ À妽º¸¦ »ý¼ºÇØ¾ß ÇϹǷΠ9°³³ª µÇ´Â À妽º¸¦ Ãß°¡ »ý¼ºÇØ¾ß ÇÑ´Ù.
[¼º´ÉÀÌ ÀúÇÏµÈ ¹ÝÁ¤±ÔÈ »ç·Ê - ¼Ó¼ºÀÌ Áߺ¹µÈ °æ¿ì]
ÇÑ Å×ÀÌºí¿¡ À妽º°¡ ¸¹¾ÆÁö¸é Á¶È¸ ¼º´ÉÀº Çâ»óµÇÁö¸¸, µ¥ÀÌÅÍ ÀÔ·Â, ¼öÁ¤, »èÁ¦¿¡ ´ëÇÑ ¼º´ÉÀº ÀúÇϵȴÙ. ±×·¡¼ ÀÏ¹Ý ¾÷¹« ó¸®(¿Â¶óÀμº ¾÷¹«)¿¡¼´Â À妽º ¼ö¸¦ °¡±ÞÀû 7~8°³°¡ ³ÑÁö ¾Êµµ·Ï ÇÏ´Â °ÍÀÌ ÁÁ´Ù.
±×·±µ¥ À§ÀÇ ¸ðµ¨Àº ´Ù¸¥ ÇÊ¿äÇÑ À妽º ÀÌ¿Ü¿¡ À¯Çü±â´ÉºÐ·ùÄÚµå ¼Ó¼º¿¡ ÇØ´çÇÏ´Â À妽º¸¦ 9°³³ª Ãß°¡ÀûÀ¸·Î »ý¼ºÇØ¾ß ÇϹǷΠ½ÇÀü ÇÁ·ÎÁ§Æ®¿¡¼´Â ¾î¿ ¼ö ¾øÀÌ À妽º¸¦ »ý¼ºÇÏÁö ¾Ê°Å³ª AÀ¯Çü±â´ÉºÐ·ùÄÚµå1 Çϳª¸¸ À妽º¸¦ »ý¼ºÇÏ´Â °æ¿ì°¡ ¹ß»ýÇÑ´Ù. ÀÌ¿¡ µû¶ó AÀ¯Çü±â´ÉºÐ·ùÄÚµå1, AÀ¯Çü±â´ÉºÐ·ùÄÚµå2, AÀ¯Çü±â´ÉºÐ·ùÄÚµå3...À» ÀÌ¿ëÇÏ´Â SQLÀÇ ¼º´ÉÀÌ ÀúÇÏµÇ¾î ³ªÅ¸³ª´Â °æ¿ì°¡ ¸¹´Ù.
¸¸¾à °¢ À¯Çü Äڵ庰·Î Á¶°ÇÀ» ºÎ¿©ÇÏ¿© ¸ðµ¨ÄÚµå¿Í ¸ðµ¨¸íÀ» Á¶È¸ÇÏ´Â SQL ¹®ÀåÀ» ÀÛ¼ºÇÑ´Ù¸é ´ÙÀ½°ú °°ÀÌ ÀÛ¼ºµÈ´Ù.
SELECT ¸ðµ¨ÄÚµå, ¸ðµ¨¸í
FROM ¸ðµ¨
WHERE
( AÀ¯Çü±â´ÉºÐ·ùÄÚµå1 = '01' )
OR ( BÀ¯Çü±â´ÉºÐ·ùÄÚµå2 = '02' )
OR ( CÀ¯Çü±â´ÉºÐ·ùÄÚµå3 = '07' )
OR ( DÀ¯Çü±â´ÉºÐ·ùÄÚµå4 = '01' )
OR ( EÀ¯Çü±â´ÉºÐ·ùÄÚµå5 = '02' )
OR ( FÀ¯Çü±â´ÉºÐ·ùÄÚµå6 = '07' )
OR ( GÀ¯Çü±â´ÉºÐ·ùÄÚµå7 = '03' )
OR ( HÀ¯Çü±â´ÉºÐ·ùÄÚµå8 = '09' )
OR ( IÀ¯Çü±â´ÉºÐ·ùÄÚµå9 = '09' )
°¢ À¯Çüº°·Î ¸ðµÎ À妽º°¡ °É·Á ÀÖ¾î¾ß À妽º¿¡ ÀÇÇØ µ¥ÀÌÅ͸¦ ãÀ» ¼ö ÀÖ´Ù.
À§ ¸ðµ¨Àº ´ÙÀ½°ú °°ÀÌ Á¤±Ôȸ¦ Àû¿ëÇØ¾ß ÇÑ´Ù.
Áߺ¹¼Ó¼º¿¡ ´ëÇÑ ºÐ¸®°¡ 1Â÷ Á¤±ÔÈÀÇ Á¤ÀÇÀÓÀ» °í·ÁÇÏ¸é ¸ðµ¨ Å×À̺íÀº 1Â÷Á¤±ÔÈÀÇ ´ë»óÀÌ µÈ´Ù. ·Î¿ì´ÜÀ§ÀÇ ´ë»óµµ 1Â÷ Á¤±ÔÈ ´ë»óÀÌ µÇÁö¸¸, Ä÷³ ´ÜÀ§·Î Áߺ¹µÇ´Â °æ¿ìµµ 1Â÷ Á¤±ÔÈ ´ë»óÀÌ µÈ´Ù. µû¶ó¼ ¸ðµ¨¿¡ ´ëÇØ 1Â÷ Á¤±Ôȸ¦ Àû¿ëÇÏ¸ç ´ÙÀ½°ú °°ÀÌ ºÐ¸®µÉ ¼ö ÀÖ´Ù.
[¼º´ÉÀÌ ÀúÇÏµÈ ¹ÝÁ¤±ÔÈ »ç·Ê - ¼Ó¼ºÀÌ Áߺ¹µÈ °æ¿ì]
ÇϳªÀÇ Å×ÀÌºí¿¡ µ¥ÀÌÅÍ 9°³°¡ ¹Ýº¹ÀûÀ¸·Î ³ª¿µÇ¾î ÀÖÀ» ¶§´Â À妽º »ý¼ºÀÌ ¾î·Á¿üÁö¸¸, Á¤±Ôȸ¦ ÅëÇØ ºÐ¸®ÇÑ ÀÌÈÄ¿¡´Â À妽º Ãß°¡ »ý¼ºÀÌ 0°³°¡ µÇ¾ú°í, ºÐ¸®µÈ Å×ÀÌºí ¸ðµ¨±â´ÉºÐ·ùÄڵ忡¼ PK À妽º¸¦ »ý¼ºÇÏ¿© ÀÌ¿ëÇÔÀ¸·Î½á ¼º´ÉÀÌ Çâ»óµÉ ¼ö ÀÖ´Ù.
¸¸¾à °¢ À¯ÇüÄڵ庰·Î Á¶°ÇÀ» ºÎ¿©ÇÏ¿© ¸ðµ¨ÄÚµå¿Í ¸ðµ¨¸íÀ» Á¶È¸ÇÏ´Â SQL ¹®ÀåÀ» ÀÛ¼ºÇÑ´Ù¸é ´ÙÀ½°ú °°ÀÌ ÀÛ¼ºµÈ´Ù.
SELECT A.¸ðµ¨ÄÚµå, A.¸ðµ¨¸í
FROM
¸ðµ¨ A,
¸ðµ¨±â´ÉºÐ·ùÄÚµå B
WHERE
( B.À¯ÇüÄÚµå = 'A' AND B.±â´ÉºÐ·ùÄÚµå = '01' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
OR ( B.À¯ÇüÄÚµå = 'B' AND B.±â´ÉºÐ·ùÄÚµå = '02' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
OR ( B.À¯ÇüÄÚµå = 'C' AND B.±â´ÉºÐ·ùÄÚµå = '07' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
OR ( B.À¯ÇüÄÚµå = 'D' AND B.±â´ÉºÐ·ùÄÚµå = '01' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
OR ( B.À¯ÇüÄÚµå = 'E' AND B.±â´ÉºÐ·ùÄÚµå = '02' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
OR ( B.À¯ÇüÄÚµå = 'F' AND B.±â´ÉºÐ·ùÄÚµå = '07' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
OR ( B.À¯ÇüÄÚµå = 'G' AND B.±â´ÉºÐ·ùÄÚµå = '03' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
OR ( B.À¯ÇüÄÚµå = 'H' AND B.±â´ÉºÐ·ùÄÚµå = '09' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
OR ( B.À¯ÇüÄÚµå = 'I' AND B.±â´ÉºÐ·ùÄÚµå = '09' AND A.¸ðµ¨ÄÚµå = B.¸ðµ¨ÄÚµå )
À§ SQL ±¸¹®Àº À¯ÇüÄÚµå+±â´ÉºÐ·ùÄÚµå+¸ðµ¨Äڵ忡 À妽º°¡ °É·Á ÀÖÀ¸¹Ç·Î À妽º¸¦ ÅëÇØ µ¥ÀÌÅ͸¦ Á¶È¸ÇÏ¿© ¼º´ÉÀÌ Çâ»óµÈ´Ù.
½ÇÀü ÇÁ·ÎÁ§Æ®¿¡¼µµ ¸¹Àº µ¥ÀÌÅ͸ðµ¨ÀÌ Ä÷³ ´ÜÀ§¿¡¼ Áߺ¹µÈ °æ¿ì°¡ ¹ß°ßµÈ´Ù. ÆÄ±Þ È¿°ú¸¦ °è»êÇÏÁö ¾Ê°í ¹«Á¶°Ç Ä÷³ ´ÜÀ§·Î COL1, COL2, COL3... ½ÄÀ¸·Î µ¥ÀÌÅ͸𵨸µÀ» ÇÏ´Ù°¡´Â ¸ðµ¨À» ÀÌ¿ëÇÏ´Â °³¹ßÀÚ¿¡°Ô ¿ø¼ºÀ» µéÀ» Áغñ¸¦ ÇØ¾ß ÇÑ´Ù.
±×·¯¹Ç·Î µ¥ÀÌÅ͸𵨸µÀ» Àü°³ÇÒ ¶§ ±âº»ÀûÀ¸·Î Á¤±Ôȸ¦ Àû¿ëÇϵµ·Ï ÇØ¾ß ÇÑ´Ù. ÀÏ´Ü Á¤±Ôȸ¦ Àû¿ëÇÑ µ¥ÀÌÅ͸ðµ¨À» ¸¸µé°í ³ ÀÌÈÄ¿¡ ¾÷¹«ÀûÀ¸·Î ¹ß»ý½ÃÅ°´Â Æ®·£Àè¼ÇÀÇ ¼º°Ý, ºÐ»ê ȯ°æ µîÀÇ Á¶°Ç¿¡ µû¶ó ¹ÝÁ¤±Ôȸ¦ Àû¿ëÇϵµ·Ï ÇØ¾ß ÇÑ´Ù.
|