Question

sqlserver2008从一个表中模糊查询并分页

select * from bbs where title like '%呵呵%';再从这个结果中查询出前10条数据。
这样的要求的SQL语句怎么写？
我需要做这样一个分页！

Answer 1

select * from (
select * from(
select b.*,rownum rn from bbs b where title like '%呵呵%'
and rownum<=10)
where rn<=分页的上限)
where rn>分页的下限

Answer 2

select * from (
select * from(
select b.*,rownum rn from bbs b where title like '%呵呵%'
and rownum<=10)
where rn<=分页的上限)
where rn>分页的下限

Answer 3

加个条件：where rownum <= 10

select * from bbs where title like '%呵呵%'
and rownum <= 10;

Answer 4

select top 10 * from bbs where title like '%呵呵%'

Answer 5

select * from bbs where title like '%呵呵%' limit 0,10