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