|
|
|
|
ÇÁ¸®¸Ç / 2001-10-25 / ¿ÀÈÄ 7:36:18 / 211.241.34.197
Á¶È¸¼ö : 123
|
[Áú¹®] ¶È°°Àºµ¥¿ä.. |
> > > >
> > > >
> > > > 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
>
> -----------------------------------------------
>
> ÀÌ·¸°Ô µÎ¹ø¿¡ °ÉÃļ Äõ¸®¸¦ ³¯·Á º¸±¸, °á°úÄ¡¸¦ È®ÀÎ Çغ¸¼Å¿ä..
>
> ÀÌ»óŸ....¤Ñ¤Ñ
-----------------------------------------------------------
ÀÌ¿¡ ÀÖ´Â °ÍÀ¸·Î Çϸé.
10-4
10-4
11-17
11-19
11-14
11-23
11-14
10-6
11-17
11-27
11-12
10-9
11-26
11-23
11-17
11-2
10-29
11-16
10-28
11-25
11-19
11-25
11-2
11-20
11-17
11-17
11-1
ÀÌ·¸°Ô ³ª¿À°í
µÎ¹ø°.. .
bir_month = 10 AND bir_day >= 28
À̰͸¸ °Ë»öÇϸé.
10-4
10-4
10-6
10-9
10-29
10-28
10-28
10-28
10-28
10-9
10-5
10-9
10-7
10-4
10-7
10-8
10-28
ÀÌ·¸°Ô µÇ°í..
bir_month = 11 AND bir_day <= 3
ÀÌ°ÍÀ¸·Î¸¸ Çϸé.
11-17
11-19
11-14
11-23
11-14
11-17
11-27
11-12
11-26
11-23
11-17
11-2
11-16
11-25
11-19
11-25
11-2
11-20
11-17
11-17
11-1
ÀÌ·¸°Ô ´ëÃæ ³ª¿É´Ï´Ù.
|
|
|
|