select Mo,BarCode,Flag form Scanbarcode where Flag='1'select Mo,BarCode,Flagform Scanbarcode where Flag='2'列出所有Flag=1的盒号列出所有Flag=2的盒号select Mo,count(BarCode),Flag form Scanbarcode where Flag='1' group by moselect Mo,count(BarCode),Flagform Scanbarcode where Flag='2' group by mo列出所有Flag=1的盒数列出所有Flag=2的盒数 |