摘要：ROW_NUMBER()做分页时用：取Id为50到60之间的数据，把它放到子查询中，不然获取不了num列select * from(select ROW_NUMBER() over(order by id)as num,* from Books)as t where num>=50 and num ... 阅读全文