首页 > 代码库 > 数据库分页

数据库分页

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

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

linq: 

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