µo«H¤H: johnrich () ¬ÝªO: sequel ¤é´Á: Wed Feb 9 11:42:49 2000 ¼ÐÃD: Re: ±Ï©R!!¦³Ãödistinctªº°ÝÃD ==> DOOHAN (DOOHAN SU) ªº¤å³¹¤¤´£¨ì: >¶Ù~~ >¤p§Ì¦³¤@°ÝÃD,´N¬O¥Îaccess¼gSQLªº«ü¥O¹J¨ì >Ãþ¦üselect count(distinct name) >³o¼Ëªº»yªkaccess¤£¤ä´©....½Ð°Ý­Ó¬°¥ý¶i >access¬O§_¦³¥t¤@ºØ¦³¬ÛÃö¥\¯àªº±Ô­zªk°Ú >¥ >¥ýÁÂÁÂÅo »yªk Count(expr) ³o expr ¼Ð¦ìÂI¥Nªí¤@­Ó¥Î¨ÓÃѧOÄæ¦ìªº¦r¦ê¹Bºâ¦¡¡A¥B¸ÓÄæ¦ì¥]§t±z±N­n­pºâªº¸ê®Æ©Î¤@­Ó¹Bºâ¦¡ªº¸ê®Æ¡A¨Ï¥Î¦¹Äæ¦ì¤¤ªº¸ê®Æ°õ¦æ­pºâ¡C¦b expr ¤¤ªº¹Bºâ¤¸¥i¥H¥]§t¤@­Ó¸ê®ÆªíÄæ¦ìªº¦WºÙ©Î¤@­Ó¨ç¼Æ (¦¹¨ç¼Æ¥i¥H¬O¤@­Ó¤º³¡©Î¨Ï¥ÎªÌ©w¸qªº¡A¦ý¤£¯à¬O¨ä¥¦ SQL »E¦X¨ç¼Æ)¡C±z¥i¥H­pºâ¥ô¦óºØÃþªº¸ê®Æ¡A¥]§t¤å¦r¸ê®Æ¡C µù¸Ñ ±z¥i¥H¨Ï¥Î Count ­pºâ¤@­Ó©³¼h¬d¸ßªº°O¿ý¼Æ¡C¨Ò¦p¡A±z¥i¥H¨Ï¥Î Count ­pºâ¤w°e¦Ü¤@«ü©w°ê®aªº³fª«ªº­q³æ¼Æ¶q¡C ÁöµM expr ¯à¦b¤@­ÓÄæ¦ì¤W°õ¦æ¤@­Ó­pºâ¡A¦ý Count ¥u¬O²³æ¦a±N³o¨Ç°O¿ýªº¼Æ¶q­pºâ¥X¨Ó¡C¨Ã¤£­­¨î°O¿ý¤§¤¤©ÒÀx¦sªº¬O¤°»ò¼Ëªº­È¡C Count ¨ç¼Æ¤£­pºâ°O¿ý¤¤¨ã¦³ Null ªºÄæ¦ì¡A°£«D expr ¬O¬P¸¹ (*) ¸U¥Î¦r¤¸¡C¦pªG±z¨Ï¥Î¬P¸¹¡ACount ±N­pºâ©Ò¦³°O¿ýªº¼Æ¶q¡A¥]§t¨º¨Ç¨ã¦³ Null ªºÄæ¦ì¡CCount(*) °ò¥»¤W¤ñ Count ([Column Name]) §Ö¡C¤£­n±N¬P¸¹¥]§t¦b¤Þ¸¹ (' ')¤§¤¤¡C¤U¦C½d¨Ò¬°­pºâ¦b­q³æ¸ê®Æªí¤§¤¤ªº°O¿ý¼Æ¶q¡G SELECT Count(*) AS TotalOrders FROM Orders; ¦pªG­n expr ÃѧO¦h­«Äæ¦ì¡A¦b¦Ü¤Ö¦³¤@­ÓÄæ¦ìªº­È¤£¬° Null ªº±¡ªp¤U¡A«h Count ¨ç¼Æ´N¥u·|­pºâ¤@µ§°O¿ý¡C¦pªG¥þ³¡ªº«ü©wÄæ¦ì¬° Null¡A¨S¦³°O¿ý·|³Q­pºâ¡C±NÄæ¦ì¦WºÙ¨Ï¥Î (&) ¤À¹j¡C¤U¦C½d¨ÒÅã¥Ü¦p¦ó­­¨î­pºâ¦b°e³f¤é´Á©Î³f¹B¬Ò¤£¬° Null ±¡ªp¤Uªº°O¿ý¡G SELECT Count('ShippedDate & Freight') AS [Not Null] FROM Orders; ¦b¤@­Ó¬d¸ß¹Bºâ¦¡¤§¤¤±z¥i¥H¨Ï¥Î Count¡C±z¥ç¥i¥H¦b QueryDef ª«¥óªº SQL Äݩʤ§¤¤¡A©Î·í«Ø¥ß¤@­Ó¥H SQL ¬d¸ß¬°°ò¦ªº Recordset ª«¥ó®É¡A¨Ó¨Ï¥Î¦¹¹Bºâ¦¡¡C -- * Origin: ¤¤¤s¤j¾Ç-¬üÄR¤§®qBBS * From: 163.15.196.11 [¤w³q¹L»{ÃÒ] .