比如查询business_id字段的值重复出现的次数
SELECT count(business_id), business_id FROM AM_BALANCE_11 GROUP BY business_id HAVING count(business_id)>1
sql查询某个字段的值重复出现的次数
最新推荐文章于 2023-06-23 16:27:02 发布
比如查询business_id字段的值重复出现的次数
SELECT count(business_id), business_id FROM AM_BALANCE_11 GROUP BY business_id HAVING count(business_id)>1