SELECT COUNT(*) AS barCodeNum,barCodeFROM tb_erp_qFlan_storListGROUP BY barCodeHAVING (COUNT(barCode) > 1)