When SQLServer sorting recording and reading will affect the outcome?

It is found that when doing the procedure, I use a stored procedure, when read second pages of results found there are many repetitive content with the first page,

Below to begin the test.:

Create table


create table abc
(
id int primary key identity(1,1),
forder int default 0
)
Table abc, only ID and Forder two column

Bulk insert 10 data, the first four is Forder 1, six is Forder 0

If the total data


Following the use of ranking query



This is the fourth conditions and results, taking the first 6 to 8 to get the results are not the same, ranking only to the Forder in ascending order, do not write the ID Case,

Who you have encountered this problem

Posted by Darnell at November 23, 2013 - 7:55 PM