这个能合并成一句吗?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 co

来源:学生作业帮助网 编辑:六六作业网 时间:2024/04/29 02:02:20
这个能合并成一句吗?selectcount(ITEMKIND)fromITEMwhereITEMKIND=''1'';selectcount(ITEMKIND)fromITEMwhereITEMKIND=

这个能合并成一句吗?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 co
这个能合并成一句吗?
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' ;

这个能合并成一句吗?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 co
select count(ITEMKIND) from ITEM where ITEMKIND in ('1','2','3','4','5');