17,382
社区成员




select
heckno ,
substr(xzqh,1,2)||'0000' as xzqh,
min(downstatus) as downstatus, --取最小值
min(upstatus) as upstatus --取最小值
from
table1
group by heckno ,substr(xzqh,1,2)
select heckno ,left(xzqh,2)+'0000' as xzqh,sum(downstatus) as downstatus, sum(upstatus) as upstatus from table1 group by heckno ,left(xzqh,2)