(急急急)一张表中N多个数据。把他们按照每页十个数据查询出来。万分感谢
select top 10 * from t where id not in(select top*+(pageNo -1 )*pageSize from t )
select top 10 * from Table where id in (select id from Table) 然后加分页条件
用mysql的话用limit,