復雜查詢語句
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
