select count(*) from gcm_todoke
where irai_no = '900100102' and
todoke_addr_1||todoke_addr_2||todoke_addr_3
=todoke_name_1||todoke_name_2;
where irai_no = '900100102' and
todoke_addr_1||todoke_addr_2||todoke_addr_3
=todoke_name_1||todoke_name_2;
比如查处todoke_addr_1||todoke_addr_2||todoke_addr_3组合
第一个值和下面的todoke_addr_1||todoke_addr_2||todoke_addr_3组合相等的
和
todoke_name_1||todoke_name_2组合
第一个值和下面的todoke_name_1||todoke_name_2组合相等的
的记录个数
也就是重复件数?
where irai_no = '900100102' group by
todoke_addr_1||todoke_addr_2||todoke_addr_3
union all
select todoke_name_1||todoke_name_2,count(*) from gcm_todoke
where irai_no = '900100102' group by
todoke_name_1||todoke_name_2;是这个意思吗?
和todoke_name_1 || todoke_name_2
同时相等,还是只要其中一个相等?
select distinct(t.*) from (
select todoke_addr_1||todoke_addr_2||todoke_addr_3 addr,todoke_name_1||todoke_name_2 name from gcm_todoke) t);
select count(*) from (
select distinct(t.*) from (
select todoke_addr_1||todoke_addr_2||todoke_addr_3 addr,todoke_name_1||todoke_name_2 name from gcm_todoke where irai_no = '900100102' ) t);
select distinct t.* from (
select todoke_addr_1||todoke_addr_2||todoke_addr_3 addr,todoke_name_1||todoke_name_2 name from gcm_todoke where irai_no = '900100102' ) t);
组合后的值进行相同比较查询
与
todoke_name_1 || todoke_name_2
组合后的值进行相同进行比较查询