select * from (
select t.*,rownum id from (
select serviceCode,serviceName from tb_service where fpid='0' order by pid asc
) t
where t.id<=100) tt
where tt.id>=84;
select t.*,rownum id from (
select serviceCode,serviceName from tb_service where fpid='0' order by pid asc
) t
where t.id<=100) tt
where tt.id>=84;
select t.*,rownum id from (
select serviceCode,serviceName from tb_service where fpid='0' order by pid asc
) t
where t.id<=100) tt
where tt.id>=84;这个还是错的哦
from tb_service
where fpid="0" and
rowid between "84" and "100"
order by pid asc
select serviceCode,serviceName
from tb_service
where fpid="0" and
rowid >'你的大ROWID' and rowid<'小ROWID'
order by pid asc
注意ROWID是一长串十六进制的数据 ,像这样'03092.SLDK002349203.LAK00' 总之很长不过看你的意思,好像应该是ROWNUM吧.
ROWNUM的用法
select serviceCode,serviceName
from tb_service
where fpid="0" and
rowid >100
minus
select serviceCode,serviceName
from tb_service
where fpid="0" and
and rownum<84