|
|
|
|
Leader / 2002-02-05 / ¿ÀÈÄ 6:57:41 / 211.189.136.10
Á¶È¸¼ö : 135
|
[Áú¹®] ³¯Â¥º°·Î °¡ÀÔÇÑ »ç¶÷ Á¢¼ÓÅë°èx) |
> °¡ÀÔÇÑ ³¯Â¥º°·Î °£´ÜÇÏ°Ô Á¢¼ÓÅë°è¸¦ ³»°í ½Í½À´Ï´Ù
>
> À̸§(name) ³¯Â¥(nal) ±Ý¾×(money)
> È«±æµ¿ 2002-02-1 10000
> ³ª°¡ÀÚ 2002-02-1 10000
> . . .
> . . .
>
> ÀÌ·¸°Ô ÀÖÀ»¶§ °£´ÜÈ÷ Çü½Ä¿¡ »ó°ü¾øÀÌ
>
> ³¯Â¥ °¡ÀÔÀοø ±Ý¾×
> 2-1 2 20000
> 2-2 . .
> . . .
>
> ÀÌ·¸°Ô ¸¸µé°í ½ÍÀºµ¥ ³¯Â¥º°·Î ¾î¶»°Ô ²÷¾îÁ®¾ß ÇÏÁÒ Å¿ä´Ô ÀÏÁ¤°ü¸® ºÃ´Âµ¥
> À߸𸣰ڴõ¶ó°í¿ä..
> Àç¹ß ´äº¯ÂÍ ºÎŹÇÕ´Ï´Ù
-----------------------------------------------------------
³¯Â¥ Çʵå¸í: ADATE
ID Çʵå¸í : AID
±Ý¾× Çʵå¸í : ACCOUNT
SELECT ADATE, COUNT(AID), SUM(ACCOUNT) FROM Å×À̺í¸í GROUP BY ADATE
¤Ñ¤Ñ¤» ÀÌ·¸°Ô Çغ¸½Ã¸é µÉµí...
-_-;; À̱⠾ƴѰ¡...
Çغ¸½Ã±¸¿ä ´Ô²²¼ ¿øÇϽô ´äÀ̽ÅÁö È®ÀÎÇغ¸¼¼¿ä
|
|
|