rownum 的用法要用select嵌套才可以的

最新推荐文章于 2021-11-02 21:33:20 发布

原创最新推荐文章于 2021-11-02 21:33:20 发布 · 1.5k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#null

本文介绍了一个复杂的SQL查询案例，通过对特定字段如VREGION、ERRORCODE等的筛选与转换，从GSMEMPTYCDR表中获取了第6到第10条记录。此查询涉及错误码的过滤及描述转换，旨在展示如何高效地从大型数据集中提取有用信息。

select * from
(
select VREGION,
       HREGION,
       CDRTYPE,
       TELNUM,
       OTHERTELNUM,
       IMSI,
       MSRN,
       MSCID,
       STARTTIME,
       DURATION,
       SERVICECODE,
       LOCALFEE,
       ROAMFEE,
       SOURFILENAME,
       TOLLFEE,
       PROCESSTIME,
       BILLINGCYCLE,
       '[' || ERRORCODE || ']' ||
       (select name
          from code_dict
         where catalog = 'ERRORCODE'
           and code = ERRORCODE) as ERRORCODE,
       rownum rownum1
from GSMEMPTYCDR
where VREGION = '634'
   and ((errorcode not like 'BAK_%' and errorcode not like 'NEW_%') or
       errorcode is null)
) where
    rownum1 > 5
   and rownum1 <= 11