34,590
社区成员
发帖
与我相关
我的任务
分享
select url,ids from myurl where ids>900 and ids<=1000
select url,ids from myurl where ids>700 and ids<=800
select url,ids from myurl where ids>0 and ids<=100
select url,ids from myurl where ids>300 and ids<=400
select url,ids from myurl where ids>100 and ids<=200
select url,ids from myurl where ids>200 and ids<=300
select url,ids from myurl where ids>400 and ids<=500
select url,ids from myurl where ids>500 and ids<=600
select url,ids from myurl where ids>600 and ids<=700
select url,ids from myurl where ids>800 and ids<=900
select url,ids from myurl where ids>1100 and ids<=1200
select url,ids from myurl where ids>1000 and ids<=1100
select url,ids from myurl where ids>1200 and ids<=1300
select url,ids from myurl where ids>1400 and ids<=1500
select url,ids from myurl where ids>1300 and ids<=1400
select url,ids from myurl where ids>1600 and ids<=1700
select url,ids from myurl where ids>1500 and ids<=1600
select url,ids from myurl where ids>1800 and ids<=1900
select url,ids from myurl where ids>2000 and ids<=2100
select url,ids from myurl where ids>1700 and ids<=1800
select url,ids from myurl where ids>1900 and ids<=2000
select url,ids from myurl where ids>2200 and ids<=2300
select url,ids from myurl where ids>2100 and ids<=2200
select url,ids from myurl where ids>2400 and ids<=2500
select url,ids from myurl where ids>2600 and ids<=2700
select url,ids from myurl where ids>2800 and ids<=2900
select url,ids from myurl where ids>3000 and ids<=3100
select url,ids from myurl where ids>2300 and ids<=2400
select url,ids from myurl where ids>2500 and ids<=2600
select url,ids from myurl where ids>2700 and ids<=2800
select url,ids from myurl where ids>2900 and ids<=3000
select url,ids from myurl where ids>3100 and ids<=3200
select url,ids from myurl where ids>3300 and ids<=3400
select url,ids from myurl where ids>3500 and ids<=3600
select url,ids from myurl where ids>3200 and ids<=3300
select url,ids from myurl where ids>3400 and ids<=3500
select url,ids from myurl where ids>3700 and ids<=3800
select url,ids from myurl where ids>3600 and ids<=3700
select url,ids from myurl where ids>3900 and ids<=4000
select url,ids from myurl where ids>3800 and ids<=3900
select url,ids from myurl where ids>4000 and ids<=4100
select url,ids from myurl where ids>4100 and ids<=4200
select url,ids from myurl where ids>4300 and ids<=4400
select url,ids from myurl where ids>4200 and ids<=4300
select url,ids from myurl where ids>4400 and ids<=4500
select url,ids from myurl where ids>4600 and ids<=4700
select url,ids from myurl where ids>4800 and ids<=4900
select url,ids from myurl where ids>4500 and ids<=4600
select url,ids from myurl where ids>4700 and ids<=4800
select url,ids from myurl where ids>4900 and ids<=5000
.
.
.
select url,ids from myurl where ids>300 and ids <=400 WITH(TABLOCK)
select url,ids from myurl where ids>900 and ids<=1000 UNION ALL
select url,ids from myurl where ids>700 and ids<=800 UNION ALL
select url,ids from myurl where ids>0 and ids<=100 UNION ALL
select url,ids from myurl where ids>300 and ids<=400
....
SELECT * FROM TB WITH (TABLOCK)
?