close

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

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


arrow
arrow
    全站熱搜

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

    E-mail轉寄