Posted on 2011-09-16 09:45
xcp 閱讀(555)
評論(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: 聯系我