关于分页问题解决方法

1 select Top 10 字段 from tb where id not in (select top 100 id from tb)

2

//获取当前页的数据
            sSql = @"select * from
                    (select {0}, Row_number() over(order by {1}) as RowNumber {2})
                    as tmpTable
                    where tmpTable.RowNumber between {3} and {4}
                    ";
            sSql = string.Format(sSql, fields, orderBy, sql,
                (pager.CurrentPage - 1) * pager.PageSize + 1, pager.CurrentPage * pager.PageSize);