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Êý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
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Ð͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ÍøÉÏÕÒµ½µÄ¶¼ÊÇasp.net
ÓÐûÓÐaspµÄµ¼Èëµ¼³öÍêÕû´úÂë
ÒýÓÃ
CSDNÉÏÄãËÑËÑ ¾ÍÓкܶà Õâ¸öÊǵ¼³öhttp://topic.csdn.net/u/20100104/10/fd959988-1ea6-46eb-9fe3-c4fe0e5ba234.html?8966
²»ÊÇµÄ ÎÒÏÖÔÚÄܵ¼ÈëºÍµ¼³ ......