摘要: 三种分页方式 关键字:NOT IN , MAX(ID) , ROW_NUMBER()select top 10 * from Users where UserID not in (select top (2*10) userid from users)select top 10 * from users where userid>( select isnull(max(userid),0) from ( select top (10*2) userid from users order by userid ) a)o... 阅读全文
posted @ 2011-12-09 17:55 醉低调 阅读(588) 评论(0) 推荐(0) 编辑