Description: unexpected paging result with ORDER BY [Column A ] ASC OFFSET 0 ROWS FETCH FIRST 1 ROWS ONLY.
If [Column A ] have the same value.
Condition:
1. Use expression: ORDER BY [Column A] ...
2. [Column A] : all row have the same value.
Preproduction:
Case 1:
SELECT [Id],[Date]
FROM [TestDateoffset]
ORDER BY [Date] ASC
OFFSET 0 ROWS
Result:
Id Date
1 2015-01-24 21:40:30.0441628 +07:00
2 2015-01-24 21:40:30.0441628 +07:00
3 2015-01-24 21:40:30.0441628 +07:00
4Go to the complete details ...