select * from (
select * from(
select b.*,rownum rn from bbs b where title like '%呵呵%'
and rownum<=10)
where rn<=分页的上限)
where rn>分页的下限
加个条件：where rownum <= 10
select * from bbs where title like '%呵呵%'
and rownum <= 10;
select top 10 * from bbs where title like '%呵呵%'
内容全部来源于网络收集，如有侵权，请联系网站删除!