´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • ûÇæÔñýѨ / 2002-09-03 / ¿ÀÈÄ 1:42:49 / 203.255.3.190
    Á¶È¸¼ö : 150
    [Áú¹®] ÀÌ°Ç ¹«½¼ ¸Þ¼¼Áö¿¡¿©???
    > [Microsoft][ODBC SQL Server Driver][SQL Server]Column name 'dage_com.code' is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause.
    > /shop/09/index.asp, line 114
    >
    -----------------------------------------------------------

    ÇØ´ç ¿¡·¯´Â order byÀý¿¡ »ç¿ëÇÑ Ä®·³Àº code¶õ ³ðÀÌ

    aggregate function¿¡ Æ÷ÇÔµÇÁö ¾Ê°í group byÀý¿¡ ³ª¿Í ÀÖÁö ¾Ê´Ù´Â ¶æÀÔ´Ï´Ù.

    group by¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº ÄÚ³­´ÔÀÇ È¨ÆäÀÌÁö¸¦ Âü°íÇϽñ⠹ٶø´Ï´Ù.

    http://sqler.pe.kr/sql2k/28.asp

    Byte * 200 Byte À̳»·Î ÀÔ·ÂÇϼ¼¿ä À̸§ : Æнº¿öµå :