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