这个能合并成一句吗?selectcount(ITEMKIND)fromITEMwhereITEMKIND='1';selectcount(ITEMKIND)fromITEMwhereITEMKIND='2;selectcount(ITEMKIND)fromITEMwhereITEMKIND='3';selectcount(ITEMKIND)fromITEMwhereITEMKIND='4';selectco

Question

这个能合并成一句吗?
select count(ITEMKIND) from ITEM where ITEMKIND='1' ;
select count(ITEMKIND) from ITEM where ITEMKIND='2 ;
select count(ITEMKIND) from ITEM where ITEMKIND='3' ;
select count(ITEMKIND) from ITEM where ITEMKIND='4' ;
select count(ITEMKIND) from ITEM where ITEMKIND='5' ;

Answer 1

select count(ITEMKIND) from ITEM where ITEMKIND in ('1','2','3','4','5');