数据库分页

sqlserver:

where rownum  between  @pageSize*(@pageIndex-1)+1  and  @pageIndex*@pageSize

mysql:

SELECT * FROM test AS t1
JOIN (SELECT id FROM test ORDER BY id desc LIMIT ($page-1)*$pagesize, 1) AS t2
WHERE t1.id <= t2.id ORDER BY t1.id desc LIMIT $pagesize;

C# linq: 

 list.OrderByDescending(o => o.OrderID)
                .Skip((pageIndex-1)* pageSize)
                .Take(pageSize);