SQL常用分页

top式

 string sqltext = string.Format(" SELECT TOP {0} * FROM '表' WHERE  ('字段' NOT IN (SELECT TOP ({1} * {0}) '字段' FROM '表'  ORDER BY '字段')) ORDER BY '字段'",pageSize,pageIndex);