select * from 商品 where( (商品类别=1) or (商品类别=2) or (商品类别=3) or (商品类别=6))
商品类别指的是粮食,五金,电子,蔬菜,水果,等等这样的类别
create table test(id int identity(1,1),col varchar(100))
insert into test(col)
select top 10000 'a' from sysobjects a cross join sysobjects b
--第一种情况select * from test where id in (1,2,3,6)
--第二种情况select * from test where id=1 or id=2 or id=3 or id=6
--第三种情况select * from test where id=1 union all
select * from test where id=2 union all
select * from test where id=3 union all
select * from test where id=6