|
|
|
|
²ÀÁö / 2001-10-25 / ¿ÀÈÄ 7:08:35 / 147.6.140.128
Á¶È¸¼ö : 112
|
[Áú¹®] ¶È°°Àºµ¥¿ä.. |
> > >
> > >
> > > SELECT *
> > > FROM member
> > > WHERE (who = 'Çлý') AND (cal = '¾ç·Â') AND (bir_month = 10) AND (bir_day >= 28) OR
> > > (bir_month = 11) AND (bir_day <= 3)
> > >
> > > ÀÌ·¸°Ô °Ë»öÀ» Çϴϱñ¿ä..
> > >
> > > 11¿ù 29Àϵµ º¸ÀÌ°í 11¿ù 6Àϵµ º¸ÀÌ°í
> > > 10¿ù 4ÀÏÀÚµµ º¸ÀÌ°í Çϳ׿ë.
> > >
> > > 10¿ù 6ÀÏÀÚµµ º¸ÀÌ°í Çϳ׿ë. ^^:;;
> > >
> > >
> > >
> > -----------------------------------------------------------
> >
> > SELECT *
> > FROM member
> > WHERE
> > who = 'Çлý' AND cal = '¾ç·Â'
> > AND (( bir_month = 10 AND bir_day >= 28)
> > OR (bir_month = 11 AND bir_day <= 3 ))
> >
> > ÀÌ·¸°Ô ÇÑ ¹ø Çغ¸½Ç·Æ´Ï±î..
> >
> > ¿¬»ê ¼ø¼¸¦ Á» µûÁ® ºÁ¾ß ÇÒ°Í °°½À´Ï´Ù.
> >
> -----------------------------------------------------------
>
> ¶È°°½À´Ï´Ù. ^^:;;
>
> ¿¡±¸..
-----------------------------------------------------------
Àú´Â Àß µÇ´Âµ¥ ÀÌ»óÇÕ´Ï´Ù..
----------------------------------------------
SELECT *
FROM member
WHERE
(bir_month = 10 AND bir_day >= 28 )
OR (bir_month = 11 AND bir_day <= 3 )
----------------------------------------------
ÀÌ·¸°Ô Çغ¸½Ç·Æ´Ï±î..
¾Æ´Ï¸é
----------------------------------------------
SELECT *
FROM member
WHERE
bir_month = 10 AND bir_day >= 28
----------------------------------------------
SELECT *
FROM member
WHERE
bir_month = 11 AND bir_day <= 3
-----------------------------------------------
ÀÌ·¸°Ô µÎ¹ø¿¡ °ÉÃļ Äõ¸®¸¦ ³¯·Á º¸±¸, °á°úÄ¡¸¦ È®ÀÎ Çغ¸¼Å¿ä..
ÀÌ»óŸ....¤Ñ¤Ñ |
|
|
|