快速統計某欄位各值出現頻次的標準寫法:
SELECT VPDM, COUNT(VPDM) AS cnt FROM ipos_qtlsd GROUP BY VPDM;
GROUP BY 依欄位分組,COUNT() 計算各組筆數,適用於類別分布、重複值偵測等場景。
GROUP BY
COUNT()