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

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

全站熱搜

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