有table的欄位a 其資料有 甲 乙 甲 丙 甲 乙 select a,count(*) as acount from table group by a ORDER BY a ASC; 後 得到 a acount 丙 1 乙 2 甲 3 可是有辦法可以只取到最小值"丙"嘛??

您好﹗    試試如下﹕ select a, Min(count(*) as acount) from table group by a ================================= 有空來瞅瞅我﹗因為我是您的朋友﹐有您真好﹗ ================================

------
忻晟

改成order by count(*) asc 並取第一筆即可 select top 1 a,count(*) as acount from table group by a ORDER BY count(*) ASC;

一個不小心在Enterprise Manager中玩出下面的SQL語句..

SELECT name FROM table2
GROUP BY name
HAVING COUNT(name) = 
  (SELECT         MIN(qty)
   FROM             
       (SELECT         name, COUNT(name) AS qty
         FROM              TABLE2
         GROUP BY   name)DERIVEDTBL)

是可以找出最小值,但...不解的是DERIVEDTBL是什麼功能?? 搜尋Help找不到,而且拿掉還會出現錯誤....

謝謝..^^,受教了!!