運算加總的SUBQUERY用法....

SELECT COUNT(CNT2),CNT
FROM
(SELECT COUNT(*) CNT,COUNT(*) CNT2, POLNO
FROM TB_ADDM
GROUP BY POLNO ) AS TABLE1
GROUP BY CNT

flywang 發表在 痞客邦 PIXNET 留言(0) 人氣()