查询语句

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