查句
jonumfinishflag
PJ000028321
PJ000028330
PJ000035880
PJ000035881
PJ000036200
PJ000036201
PJ000036290

以上jonum如果有finishflag存在真和假，那么返回0，只有一那么取finishflag的值。如下果


jonumfinishflag
PJ000028321
PJ000028330
PJ000035880
PJ000036200
PJ000036290

[解决办法]
select jonum,min(finishflag)finishflag from tb group by jonum