记录一下比较难写的sql
比如统计一个代理人编号下,有不止一行数据的sql
select t.agt_cd,count(*) from (select agt_cd,id_num from temp_agent_info group by agt_cd,id_num ) t group by t.agt_cd having count(*) > 1;
记录一下比较难写的sql
比如统计一个代理人编号下,有不止一行数据的sql
select t.agt_cd,count(*) from (select agt_cd,id_num from temp_agent_info group by agt_cd,id_num ) t group by t.agt_cd having count(*) > 1;