|
sql2000：5-10sql="select top 5 * from news where iclass_select = 1 and id > max(select top 5 id from news where iclass_select = 1 orderby changtime,id ) orderby changtime,id "10-15sql="select top 5 * from news where iclass_select = 1 and id > max(select top 10 id from news where iclass_select = 1 orderby changtime,id ) orderby changtime,id"动态自己考虑参数sql2005：sql="select top 5 *,row_number() over (order by changtime,id ) AS row_index from news where iclass_select = 1 and （row_index >=5 and row_index =n and id0 =第几条and id<=第几条 |
