share 表的字段id, title, image, content, wx_cont_url, jump_url, fx_suc, hits, add_date, class_id, faburen_id, reg_time, news_author, news_src
（1）分页
select * from
( select top 100 percent * ,row_number() over (order by title desc ) as pagenum
from share where title like ‘%奖%‘order by title ) t
where t.pagenum between 5 and 1*10 order by id
（2） 分页
select top 20 * from share where id not in
(select top 10 id from share order by id) order by id
分页的SQL语句
原文：http://www.cnblogs.com/sulong/p/4861155.html
