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

[µo°Ý] Count¸ê®Æ®w¬d¸ß»yªk°ÝÃD½Ð±Ð

[µo°Ý] Count¸ê®Æ®w¬d¸ß»yªk°ÝÃD½Ð±Ð

½Ð±Ð¦pªG·Q±NCountªº±Æ§Ç¶W¹L9¡A²Ä10¦C¶µ¥Ø­×§ï¦¨Other©M²Ä10¦C¶}©lªº­È¥þ³¡¥[Á`¡C
»¡©ú½d¨Ò¡A¦pªþ¥ó~

«ÜÁÂÁ¤j®aªºÀ°¦£^^

test.zip (1.84 KB)

¥»©«³Ì«á¥Ñ Min ©ó 2010-9-9 22:38 ½s¿è

¥Îrownum...

select COL
from xxx
where rownum <=9
union
select sum(COL)
from xxx
where rownum >9

¤j·§¬O³o¼Ë~
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

ÁÂÁª©¥DªºÀ°¦£¡A·P¿E¤£ºÉ^^

TOP

¦]¬°¦³¥Î¨ì¨âºØ¸ê®Æ®w¡A¦A½Ð±ÐªO¤j¦pªG¬O¦bACCESS¦³¿ìªk°µ¨ì¶Ü?
¦]¬°Access¦n¹³¨S³o­Ó¨ç¼Æ~

TOP

¦n¹³¬Oselect top 10
¤£¬O«Ü½T©w §A¸Õ¸Õ¬Ý~
­Y¬O§Ú¦^µª¡A¨Ï±zº¡·N¡A½Ð±zÅý§Úª¾¹D¡I                  
­Y¬O§Úªº¦^ÂСA±z¤´¦³¨ä¥L¨£¸Ñ¡A¤]½Ð±z¤£¶Þ«ü±Ð¡I

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD