每日一练 进来练一下

这是别人写的两种方法

select top 100 px=identity(int,1,1) into # from sysobjects

--方法1取模

select px from # where px<>1 and px%2 <>0  and px%3<>0 and px%5<>0 and px%7<>0 or px=2 or px=5 or px=3 or px=7 

--方法2不等于乘积

select * from #

       where px>1 and px not in

       (select a.px*b.px from # a, # b where a.px>1 and b.px>1)