select djxh,
fpzl_dm,
fpzlmc,
fs,
fpqshm,
fpzzhm,
fpzt_dm,
fpztmc,
rn,
lead(rn) over(partition by djxh order by rn) rn1
from (select djxh,
fpzl_dm,
fpzlmc,
fs,
fpqshm,
fpzzhm,
fpzt_dm,
fpztmc,
row_number() over(order by djxh desc) rn
from (select m.djxh,
m.fpzl_dm,
n.fpzlmc,
m.fs,
m.fpqshm,
m.fpzzhm,
m.fpzt_dm,
z.fpztmc
from sw_fp.fp_nsrfpjc m,
sw_dm_qg.dm_fp_fpzl n,
sw_dm_qg.dm_fp_fpzt z
where m.swjg_dm like '1532301%'
and m.fpzl_dm = n.fpzl_dm
and m.fpzt_dm = z.fpzt_dm
group by m.djxh,
m.fpzl_dm,
n.fpzlmc,
m.fs,
m.fpqshm,
m.fpzzhm,
m.fpzt_dm,
z.fpztmc
))
这语句运行正常