Posted on 2011-09-16 09:45
xcp 阅读(550)
评论(0) 编辑 收藏 所属分类:
Database
不排序分页：
select *
from (select rownum as num,t.ID, t.NAME, t.MODEL, t.DEPTH, t.FATHER, t.PCS
from v_za_bzdzk t
where t.FATHER = '510502'
and PCS like '%510502400000%'
and depth = '2'
and rownum<=30) gg
where num >= 16
排序分页：
select *
from (select rownum as num, gg.*
from (select t.ID, t.NAME, t.MODEL, t.DEPTH, t.FATHER, t.PCS
from v_za_bzdzk t
where t.FATHER = '510502'
and PCS like '%510502400000%'
and depth = '2'
order by ORDERNAME) gg
where Rownum <= 30
) tt
where tt.num >= 16
名称: ♪4C.ESL | .↗Evon
口号: 遇到新问题♪先要寻找一个方案乄而不是创造一个方案こ
mail: 联系我