SELECT fee.bank_code, COUNT(1) c
FROM t_fp_fee fee
WHERE fee.fcd >= DATE '2019-6-13'
GROUP BY fee.bank_code
HAVING COUNT(1) >= 1000
注意COUNT(1) 不能改为 C,不能使用别名
SELECT fee.bank_code, COUNT(1) c
FROM t_fp_fee fee
WHERE fee.fcd >= DATE '2019-6-13'
GROUP BY fee.bank_code
HAVING COUNT(1) >= 1000
注意COUNT(1) 不能改为 C,不能使用别名