第一：
sql = "SELECT TOP " + pageCount + " * FROM b_jihua_xiangmu WHERE f_nb_jhid=" + jhid + " and f_nb_xmbm >(SELECT ISNULL(MAX(f_nb_xmbm),0) FROM ( SELECT TOP (" + pageCount + "* (" + page + "-1)) * FROM b_jihua_xiangmu where f_nb_jhid=" + jhid + "ORDER BY f_nb_xmbm ) as a )ORDER BY f_nb_xmbm";
第二：
select top 页大小 *
from table1
where id>
(select max (id) from
(select top ((页码-1)*页大小) id from table1 order by id) as T
)
order by id
第二种 页码等于1的时候 查询不出来值 不知道为什么
