客戶 筆數大於1的,如何下,即如何讓A>1的才SHOW出來 SELECT COUNT(CUSTMER) AS A,CUSTMER FROM AA_CUST WHERE ZSTATUS='B' AND CRTP='A' GROUP BY CUSTMER ORDER BY A DESC

SELECT COUNT(CUSTMER) AS A,CUSTMER FROM AA_CUST WHERE ZSTATUS='B' AND CRTP='A'  GROUP BY CUSTMER having count(CUSTMER) > 1 ORDER BY A DESC Ian

Hi:    

SELECT  COUNT(CUSTMER) AS A,
        CUSTMER 
FROM    AA_CUST
WHERE   ZSTATUS='B' AND CRTP='A' 
GROUP   BY CUSTMER ORDER BY A DESC
HAVING  COUNT(CUSTMER) > 1

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman