ACCESSÅÅÐò²¢È¡Í·10ÌõÊý¾Ý
ACCESSÊý¾Ý¿â°´ÕÕ·ÇÖ÷¼ü×Ö¶ÎÅÅÐò£¬È¡10ÌõÊý¾Ý£¬½á¹û²éѯ³ö12ÌõÊý¾ÝÀ´£¬Ôõô»ØÊÂ?лл£¡
SQL:SELECT TOP 10 * from STU_INFO ORDER BY AGE;
¹À¼ÆÊÇÒòΪµÚ10,11,12 Êý¾ÝµÄÅÅÐòÖµAGEÏàͬµÄÔÒò¡£
AGEÓÐÖØ¸´µÄ¼Ç¼°É£¬¼ì²éÒ»ÏÂ
ÈçºÎ½â¾ö SELECT TOP 1Óï¾ä¾¹È»·µ»Ø¶àÌõ¼Ç¼µÄÎÊÌ⣿¡¶²éѯ¡·
http://access911.net/index.asp?u1=a&u2=71FAB41E15DCEFF3
--911--
ÓÐÖØ¸´£¬ÔÙ¼ÓÒ»¸ö²»Öظ´µÄÅÅÐò×ֶξͿÉÒÔÁË
SELECT TOP 10 * from STU_INFO ORDER BY AGE,id
AGEÓÐÖØ¸´µÄ¼Ç¼
ÔÀ´AgeÖµÓÐÖØ¸´¾Í»áÕâÑù,³¤ÖªÊ¶ÁË.
Ïà¹ØÎÊ´ð£º
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
accessÖеÄtextÐ͵ÄÊý×Ö£¬Ôõô±È½Ï´óС°¡£¿
´ó¼ÒÖªµÀÂð?
ÒòΪÎÒÏë¸ù¾ÝÕâÒ»ÁÐÊý¾ÝµÄ´óС²éѯһЩ¶«Î÷
¾Ù¸öÀý×Ó£º
¾ÍÊÇ£¬ÎÒÓÐÒ»ÁÐÊý¾ÝΪ±àÂ룺
ÊÇtextÐ͵ÄÊý×Ö£ºÈç
1101
1102
1103
µÈ£¬
ÎÒÏÖÔÚҪȡ³ö±àÂë±È ......
ÍøÉÏÕÒµ½µÄ¶¼ÊÇasp.net
ÓÐûÓÐaspµÄµ¼Èëµ¼³öÍêÕû´úÂë
ÒýÓÃ
CSDNÉÏÄãËÑËÑ ¾ÍÓкܶà Õâ¸öÊǵ¼³öhttp://topic.csdn.net/u/20100104/10/fd959988-1ea6-46eb-9fe3-c4fe0e5ba234.html?8966
²»ÊÇµÄ ÎÒÏÖÔÚÄܵ¼ÈëºÍµ¼³ ......