select case when ZYJSMC='' then '其他' else ZYJSMC end as ZYJSMC,count(ZYJSMC) as gs from HR_RSGL_YGXX where szbm in ('010113','01011301','01011302','01011303','01011304','01011305','010101','01010101','01010102','01010103','01010104','01010105','01010106','01010107','01010108','01010109','01010110','01010111','01010112','01010113','01010114','01010115','01010116','01010117','010102','01010201','01010202','01010203','01010204','01010205','01010208','01010209','010103','01010301','01010302','01010303','01010304','01010305','01010306','01010307','01010308','01010309','01010310','010109','01010901','01010902','0101090201','0101090202','0101090203','0101090204','0101090206','01010903','01010904','01010905','01010906','01010907','010104','01010401','01010402','01010403','01010404','01010405','01010406','01010407','01010408','010105','010110','01011001','01011002','01011003','01011004','01011005','01011006','01011007','01011008','01011009','01011010','01011011','01011012','01011012','01011013','01011014','01011015','01011016','01011017','01011018','01011019','010111','010112') and szbm like '%' group by ZYJSMC order by ZYJSMC and XL1 = '专科'哪错了? 报and附近有语法错误
'010112') and szbm like '%' group by ZYJSMC order by ZYJSMC and XL1 = '专科'
===========
'010112') and szbm like '%' and XL1 = '专科'
group by ZYJSMC order by ZYJSMC
from HR_RSGL_YGXX
where XL1 = '专科'
and szbm in ('010113','01011301','01011302','01011303','01011304','01011305','010101','01010101','01010102','01010103','01010104','01010105','01010106','01010107','01010108','01010109','01010110','01010111','01010112','01010113','01010114','01010115','01010116','01010117','010102','01010201','01010202','01010203','01010204','01010205','01010208','01010209','010103','01010301','01010302','01010303','01010304','01010305','01010306','01010307','01010308','01010309','01010310','010109','01010901','01010902','0101090201','0101090202','0101090203','0101090204','0101090206','01010903','01010904','01010905','01010906','01010907','010104','01010401','01010402','01010403','01010404','01010405','01010406','01010407','01010408','010105','010110','01011001','01011002','01011003','01011004','01011005','01011006','01011007','01011008','01011009','01011010','01011011','01011012','01011012','01011013','01011014','01011015','01011016','01011017','01011018','01011019','010111','010112')
and szbm like '%'
group by ZYJSMC
order by ZYJSMC
from HR_RSGL_YGXX
where XL1 = '专科'
and szbm in ('010113','01011301','01011302','01011303','01011304','01011305','010101','01010101','01010102','01010103','01010104','01010105','01010106','01010107','01010108','01010109','01010110','01010111','01010112','01010113','01010114','01010115','01010116','01010117','010102','01010201','01010202','01010203','01010204','01010205','01010208','01010209','010103','01010301','01010302','01010303','01010304','01010305','01010306','01010307','01010308','01010309','01010310','010109','01010901','01010902','0101090201','0101090202','0101090203','0101090204','0101090206','01010903','01010904','01010905','01010906','01010907','010104','01010401','01010402','01010403','01010404','01010405','01010406','01010407','01010408','010105','010110','01011001','01011002','01011003','01011004','01011005','01011006','01011007','01011008','01011009','01011010','01011011','01011012','01011012','01011013','01011014','01011015','01011016','01011017','01011018','01011019','010111','010112')
and szbm like '%'
group by ZYJSMC
order by ZYJSMC
from HR_RSGL_YGXX
where XL1 = '专科'
and szbm in ('010113','01011301','01011302','01011303','01011304','01011305','010101','01010101','01010102','01010103','01010104','01010105','01010106','01010107','01010108','01010109','01010110','01010111','01010112','01010113','01010114','01010115','01010116','01010117','010102','01010201','01010202','01010203','01010204','01010205','01010208','01010209','010103','01010301','01010302','01010303','01010304','01010305','01010306','01010307','01010308','01010309','01010310','010109','01010901','01010902','0101090201','0101090202','0101090203','0101090204','0101090206','01010903','01010904','01010905','01010906','01010907','010104','01010401','01010402','01010403','01010404','01010405','01010406','01010407','01010408','010105','010110','01011001','01011002','01011003','01011004','01011005','01011006','01011007','01011008','01011009','01011010','01011011','01011012','01011012','01011013','01011014','01011015','01011016','01011017','01011018','01011019','010111','010112')
group by ZYJSMC,gs
order by ZYJSMC
sql=arr[0]+" " + "where" + " " +"XL1 = '专科'
" + " and" +" " +arr[1]
sql=arr[0]+" " + "where" + " " + @"XL1 = '专科'" + " and" + " " +arr[1];