摘要:
取20-30条数据常用的2种写法方法一:select top 10 * from [User] where ID>(select max(ID) from (select top 20 ID from [User] order by ID ASC ) t0)order by ID ASC方法二:select * from (select ROW_NUMBER() OVER (ORDER BY ID ) AS RowNumber , * from[User])TMPwhere RowNumber >20 and RowNumber<=30 阅读全文