select top(8) * from xyxx where xybh not in
(select top (72) xybh from xyxx order by xybh) order by xybh asc这个分页语句哪儿出错了,请各位指点,多谢
(select top (72) xybh from xyxx order by xybh) order by xybh asc这个分页语句哪儿出错了,请各位指点,多谢
select *
from (select a.*,row_number() over(order by xybh) rn from xyxx a)
where rn between 73 and 80
select *
from (select a.*,rownum rn from (select * from xyxx order by xybh) a)
where rn between 73 and 80
wkc168 做了给你