°úÁ¦´Â SQL Query ¹® ¸¸µå´Â °Çµ¥ Á¦°¡ »ý°¢ÇÏ´Â Ãâ·Âó·³ ³ª¿ÀÁú ¾Ê¾Æ¼ ¾ËÁö·Õ °í¼ö´Ôµé²² ¿©Âã´Ï´Ù.
¹®Á¦´Â "´ÙÀ½ Student1 Å×À̺í°ú Student2 Å×ÀÌºí¿¡¼ »ýÀÏÀÌ °°Àº ÇлýµéÀ» °Ë»öÇϱâ À§ÇÑ SQL ¹®ÀåÀ» ÀÛ¼ºÇ϶ó."´Â °Ì´Ï´Ù.
Student1 Å×À̺í
Çйø(SID) À̸§(Name) Çаú(Dept) »ý³â¿ùÀÏ(BDay)
20120305 ±è¿µ¼ö ÀÇ·ùÇаú 81/12/08
20120409 ÃÖ¼ö¾Æ Åë°èÇаú 79/04/01
Student2 Å×À̺í
Çйø(SID) À̸§(Name) Ãâ»ý¿¬µµ(BYear) Ãâ»ý¿ù(BMonth) Ãâ»ýÀÏ(BDate)
19970105 ±è°©¼ö 78 10 12
19980508 À̼±¾Æ 79 11 24
º¸½Ã´Ù½ÃÇÇ Student1 °ú Student2 Å×À̺íÀÌ ¼·Î ¸ð¾çÀÌ Á» ´Ù¸£°í¿ä
Àú´Â ¿ä·¸°Ô ÀÛ¼ºÀ» Çß½À´Ï´Ù.
SELECT Student1.SID, Student1.Name,
EXTRACT (YEAR FROM Student1.BDAY) YEAR,
EXTRACT (MONTH FROM Student1.BDAY) MONTH,
EXTRACT (DAY FROM Student1.BDAY) DAY,
Student2.SID, Student2.Name
FROM Student1
INNER JOIN Student2
ON Student1.YEAR=Student2.BYEAR and Student1.MONTH=Student2.BMONTH and Student1.DAY=Student2.BDate
±×·¨´õ´Ï °á°ú¹°ÀÌ
Student1 Å×À̺íÀÇ Çйø, À̸§, Ãâ»ý¿¬µµ, Ãâ»ý¿ù, Ãâ»ýÀÏ, Student2 Å×À̺íÀÇ Çйø, À̸§ ÇüÅ·Πº´½Å°°ÀÌ ³ª¿À´Âµ¥ (¿¹ : 20100507 ±è°©¼ø 90 01 01 20120102 ÀÌÁ¤¼ö)
ÀÌ°É ·¹ÄÚµå º°·Î ´Ù¸¥ ¶óÀο¡ Ãâ·ÂÀÌ µÇ°ÔÇÏ·Á¸é Query¸¦ ¾î¶»°Ô ¹Ù²ãÁà¾ß ÇÒ±î¿ä?
¿ä·±½ÄÀ¸·Î..
20100507 ±è°©¼ø 90 01 01
20120102 ÀÌÁ¤¼ö 90 01 01
¾ËÁö·Õ °í¼ö´ÔµéÀÇ µµ¿ò ºÎŹ µå¸³´Ï´Ù.
Áú¹® | 1377¸íÀÌ Àоú¾î¿ä. 18.191.29.151