Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

access sumÅÅÐò

SELECT sum(productnum) AS 'aa' from orders group by id  ORDER BY 'aa' DESC Ã²ËÆÕâÑùÅÅÐò²»ÐУ¬¼Ó²»¼Ó ORDER BY 'aa' DESC Ч¹ûÊÇÒ»ÑùµÄ£¬¾ÍÊÇËüÊÇÂҵ쬏ù±¾²»ÅÅÐò¡££¬ÒªÈçºÎ²ÅÄܽâ¾öÕâ¸öÎÊÌâ


sum(productnum)²»ÊÇÇó×ÜÊýµÄÂð¡£Ôõô»¹ÄÜÅÅÐò

access²»Ö§³Ö±ðÃûÅÅÐò

ллlzp4881£¬OKÁË


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

½â¾öaccess¼¶Áª¸üÐÂÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

CREATE TABLE Product(model integer, 
maker varchar(20), 
CONSTRAINT SAND PRIMARY KEY (model), 
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model) 
ON DELETE CASCADE ......

accessÖеÄtextÐÍÊý×Ö - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......

ÇóÖú ¹ØÓÚASP access excelµ¼ÈëºÍµ¼³ö

ÍøÉÏÕÒµ½µÄ¶¼ÊÇasp.net
ÓÐûÓÐaspµÄµ¼Èëµ¼³öÍêÕû´úÂë

ÒýÓÃ
CSDNÉÏÄãËÑËÑ ¾ÍÓкܶà Õâ¸öÊǵ¼³öhttp://topic.csdn.net/u/20100104/10/fd959988-1ea6-46eb-9fe3-c4fe0e5ba234.html?8966
²»ÊÇµÄ ÎÒÏÖÔÚÄܵ¼ÈëºÍµ¼³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ