加载中…oracle中rownum between用法
(2014-10-22 15:15:59)
标签：
股票 |
目标：条件查询，后排序，取其中一段记录，用于WEB页面分页
select * from
(select
bib,z13_title,z13_author,z13_imprint,z13_year,z13_call_no,z13_isbn_issn,z13_price,rownum
as num from
(select distinct
trim(replace(substrb(Z13U_USER_DEFINED_5,1,9),'^'))as
bib,z13_title,z13_author,z13_imprint,z13_year,z13_call_no,z13_isbn_issn,z13_price
from shu50.z30,shu50.v13
where substr(z30_rec_key,1,9)=z13_rec_key and
trim(Z30_ITEM_PROCESS_STATUS) is null
and 。。。 )
order by z13_title) a ) b
WHERE num between 10 and 255
需要二层嵌套，第一层排序，第二层给出rownum
喜欢
0
赠金笔
前一篇：体检，小胖肝脂肪浸润
后一篇：彭浦美食推荐:马记清真餐厅