之前用oracle用的rownum三层嵌套
请问Sqlserver中如何写呢
我从前台接收到了pageNumber(当前页),pageSize(每页显示的条数),和名称
我的核心语句是 select * from XXX where name like '%名称%',
求分页sql写法谢谢!
------解决方案--------------------
试试
select * from (
select row_num()OVER(ORDER BY rw_) rownum, core_.* from (
select * from bs_book where name like ?
) core_
where rownum <= ?
) outer_
where outer_.rw_ >= ?