查询实际数据--过滤重复的。SQL脚本如下,可根据例子举一反三
SELECT count(pms_org_id) duplicateCount,org_code,accounting_org_code
FROM `t_if_pms_org` GROUP BY org_code,accounting_org_code;
查询实际数据--过滤重复的。SQL脚本如下,可根据例子举一反三
SELECT count(pms_org_id) duplicateCount,org_code,accounting_org_code
FROM `t_if_pms_org` GROUP BY org_code,accounting_org_code;
转载于:https://my.oschina.net/u/3155476/blog/3056632