1create table #dblib0006 (i int not null, s char(10) not null) 2go 3insert into #dblib0006 values (1, 'row 0001') 4go 5insert into #dblib0006 values (2, 'row 0002') 6go 7insert into #dblib0006 values (3, 'row 0003') 8go 9insert into #dblib0006 values (4, 'row 0004') 10go 11insert into #dblib0006 values (5, 'row 0005') 12go 13insert into #dblib0006 values (6, 'row 0006') 14go 15insert into #dblib0006 values (7, 'row 0007') 16go 17insert into #dblib0006 values (8, 'row 0008') 18go 19insert into #dblib0006 values (9, 'row 0009') 20go 21insert into #dblib0006 values (10, 'row 0010') 22go 23insert into #dblib0006 values (11, 'row 0011') 24go 25insert into #dblib0006 values (12, 'row 0012') 26go 27insert into #dblib0006 values (13, 'row 0013') 28go 29insert into #dblib0006 values (14, 'row 0014') 30go 31insert into #dblib0006 values (15, 'row 0015') 32go 33insert into #dblib0006 values (16, 'row 0016') 34go 35insert into #dblib0006 values (17, 'row 0017') 36go 37insert into #dblib0006 values (18, 'row 0018') 38go 39insert into #dblib0006 values (19, 'row 0019') 40go 41insert into #dblib0006 values (20, 'row 0020') 42go 43insert into #dblib0006 values (21, 'row 0021') 44go 45insert into #dblib0006 values (22, 'row 0022') 46go 47insert into #dblib0006 values (23, 'row 0023') 48go 49insert into #dblib0006 values (24, 'row 0024') 50go 51insert into #dblib0006 values (25, 'row 0025') 52go 53insert into #dblib0006 values (26, 'row 0026') 54go 55insert into #dblib0006 values (27, 'row 0027') 56go 57insert into #dblib0006 values (28, 'row 0028') 58go 59insert into #dblib0006 values (29, 'row 0029') 60go 61insert into #dblib0006 values (30, 'row 0030') 62go 63insert into #dblib0006 values (31, 'row 0031') 64go 65insert into #dblib0006 values (32, 'row 0032') 66go 67insert into #dblib0006 values (33, 'row 0033') 68go 69insert into #dblib0006 values (34, 'row 0034') 70go 71insert into #dblib0006 values (35, 'row 0035') 72go 73insert into #dblib0006 values (36, 'row 0036') 74go 75insert into #dblib0006 values (37, 'row 0037') 76go 77insert into #dblib0006 values (38, 'row 0038') 78go 79insert into #dblib0006 values (39, 'row 0039') 80go 81insert into #dblib0006 values (40, 'row 0040') 82go 83insert into #dblib0006 values (41, 'row 0041') 84go 85insert into #dblib0006 values (42, 'row 0042') 86go 87insert into #dblib0006 values (43, 'row 0043') 88go 89insert into #dblib0006 values (44, 'row 0044') 90go 91insert into #dblib0006 values (45, 'row 0045') 92go 93insert into #dblib0006 values (46, 'row 0046') 94go 95insert into #dblib0006 values (47, 'row 0047') 96go 97insert into #dblib0006 values (48, 'row 0048') 98go 99insert into #dblib0006 values (49, 'row 0049') 100go 101select * from #dblib0006 where i<50 order by i 102go 103select * from #dblib0006 where i>=25 order by i 104go 105