在线等,sql一次查询多个条件的统计答:创建表。插入数据 create table a(id int,name varchar(1),category varchar(2),other varchar(2),count int);insert into a values (1,'a','xx','dd',1);insert into a values (2,'a','xx','ff',1);insert into a values (3,'a','yy','dd',1);insert into a values (4,...
sql按多字段值条件查询问题答:如果menuid是列表1,5,8 那么select distinct companyid from menutable where menuid in('1','5','8')(如果menuid为字符类型,数字类型将引号去掉)如果传入的menuid是个字符串1,5,8 那么写成select distinct companyid from menutable where ',1,5,8,' like '%,'+cast(menuid as varchar)+'...