日期:2014-05-17 浏览次数:20602 次
if object_id('[TB]') is not null drop table [TB]
go
create table [TB] (ID int,Text nvarchar(20))
insert into [TB]
select 1,'8888' union all
select 2,'2222' union all
select 3,'11111' union all
select 4,'098023' union all
select 5,'929829842' union all
select 6,'9908082083' union all
select 7,'8777923' union all
select 8,'89789' union all
select 9,'897982932'
select * from [TB]
SELECT * FROM TB WHERE id%3=1
/*
ID Text
1 8888
4 098023
7 8777923*/