ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

½Ð°Ý¦p¦ó¥ÎMySQL¼g¤@­Ó¥H¥ý¶i¥ý¥Xªº¤è¦¡¨Ó¨ú±o²£«~ªº¼Æ¶q»P¥­§¡»ù®æ

½Ð°Ý¦p¦ó¥ÎMySQL¼g¤@­Ó¥H¥ý¶i¥ý¥Xªº¤è¦¡¨Ó¨ú±o²£«~ªº¼Æ¶q»P¥­§¡»ù®æ

½Ð°Ý¦p¦ó¥ÎMySQL¼g¤@­Ó¥H¥ý¶i¥ý¥Xªº¤è¦¡¨Ó¨ú±o²£«~ªº¼Æ¶q»P¥­§¡»ù®æ
¤p§Ì¹ê¦b·Q¤£¥X¸Ó¦p¦ó¼g¥X¨Ó,¶R¶i½æ¥X¶·¥H¤é´Á¬°¥D
­n¨ú±o¥Ø«e²£«~ªº³Ñ¾l¼Æ¶q»P³Ñ¾l¼Æ¶qªº¦¨¥»§¡»ù,²£«~©ú²Ó¦pªþ¥ó

test.rar (612 Bytes)

²£«~¶R½æ¸ê°T

select sum(¼Æ¶q), avg(»ù®æ) from ¸ê®Æªí order by date;

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD