access2000 ллselect sum(*) from products where id in (5,2,3,4,4,5,6,8,8,6); Õâ¸öÖظ´µÄÒ²¿ÉÒÔËã½øÈ¥£¿ Ŷ£¬Õâ¸öµ¹ÍüÁË£¬ÎÒÔÙ¿´¿´ select sum(price) from products where id in (5,2,3,4,4,5,6,8,8,6);
Öظ´Ã»Ê£¬²»Ó°Ïì ¶ÔÓÚÖظ´µÄÅä¼þ²»»áÖ»¼ÆËãÒ»´Î°É£¿ÎҵijõÖԿɲ»ÊÇÕâÑùµÄ¡¡ Ò»¾äsql¸ã²»¶¨£¬¿ÉÒÔÏÈÓÃselect * from products where id in (5,2,3,4,4,5,6,8,8,6)²éѯ³ö¸½¼þ°üÄÚ¸½¼þµ¥¼Û£¬È»ºóÔÙ°´Ã¿ÖÖ¸½¼þ¸öÊýÀÛ¼ÆÇóºÍ¡£ select sum(price) from products where id='5'or id='2'or id='3'......