|
|
|
|
»ç¶ó / 2002-01-03 / ¿ÀÀü 12:38:56 / 210.178.30.238
Á¶È¸¼ö : 132
|
[Áú¹®] ¿ÀÌ ¾Æ´Ñ Çà¿¡¼ °ªÀÇ ÇÕ ±¸Çϱâ..6 |
> > mon tue wed
> > ------------------ <= Å×À̺í À̸§: table
> > a 1 2 3
> > b 3 6 1
> > c 3 5 5
> >
> > À§¿Í °°Àº Å×ÀÌºí¿¡¼ a,b,cÀÇ mon,tue,wed ÀÇ ÇÕÀ» ±¸ÇÏ·Á¸é sql¹®À» ¾î¶»°Ô ½á¾ßÇÏÁÒ?(ÇÕÀº °¢°¢ a,b,c µû·Î ±¸ÇÏ·Á°í ÇÕ´Ï´Ù.)
> >
> >
> -----------------------------------------------------------
>
±Ã±ÝÇÑ °Ô ÀÖ½À´Ï´Ù
¿©±â¼ ColÀÇ Àǹ̴ ¹¹ÁÒ?
¿ Áï Çʵ带 ÀǹÌÇÏ´Â °Å·ª¸é ¾ÈµÇÁö ¾Ê³ª¿ä?
¼¼·Î°¡ ¾Æ´Ñ °¡·ÎÀÇ ÇÕÀ» ±¸ÇÏ´Â °Çµ¥ ....
¾Æ´Ï¸é ÀÓÀÇ·Î ÁöÁ¤ÇØ ÁÖ´Â °Ç°¡¿ä?
ºü¸¥ ´äº¯ ºÎŹµå¸³´Ï´Ù.
> select Col, (mon+tue+wed) as 'ÇÕ°è'
> from table
>
>
-----------------------------------------------------------
|
|
|