这个能合并成一句吗?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/11/15 00:11:40
这个能合并成一句吗?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');