| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149 |
- CREATE VIEW "nl_jc_bjcz_view" AS SELECT d.rownum,
- d.bsm,
- d.xzqhdm,
- d.bjbh,
- d.czzt,
- d.czsj,
- d.cznr,
- d.czbg,
- d.jlry,
- d.gxsj,
- d.bz,
- d.yskzjbz,
- d.sjtbzt,
- d.tbsj,
- d.czjg,
- d.xcpcry,
- d.xcpcrylxdh,
- d.czfa,
- d.ksczsj,
- d.wcczsj,
- d.xctpspwj
- FROM ( SELECT row_number() OVER (PARTITION BY nl_jc_bjcz.bsm ORDER BY nl_jc_bjcz.tbsj DESC) AS rownum,
- nl_jc_bjcz.bsm,
- nl_jc_bjcz.xzqhdm,
- nl_jc_bjcz.bjbh,
- nl_jc_bjcz.czzt,
- nl_jc_bjcz.czsj,
- nl_jc_bjcz.cznr,
- nl_jc_bjcz.czbg,
- nl_jc_bjcz.jlry,
- nl_jc_bjcz.gxsj,
- nl_jc_bjcz.bz,
- nl_jc_bjcz.yskzjbz,
- nl_jc_bjcz.sjtbzt,
- nl_jc_bjcz.tbsj,
- nl_jc_bjcz.czjg,
- nl_jc_bjcz.xcpcry,
- nl_jc_bjcz.xcpcrylxdh,
- nl_jc_bjcz.czfa,
- nl_jc_bjcz.ksczsj,
- nl_jc_bjcz.wcczsj,
- nl_jc_bjcz.xctpspwj
- FROM ztfbk_sjg.nl_jc_bjcz) d
- WHERE d.rownum = 1;
- ALTER TABLE "nl_jc_bjcz_view" OWNER TO "adq_sjg";
- CREATE VIEW "nl_jc_bjfx_view" AS SELECT d.rownum,
- d.bsm,
- d.bjbh,
- d.bjdwwz,
- d.xcpcry,
- d.xcpcrylxdh,
- d.ddxcsj,
- d.xczkms,
- d.zsry,
- d.zsrylxdh,
- d.zsrydw,
- d.zsryfxjs,
- d.xcryfxbg,
- d.zsryfxsj,
- d.fxnr,
- d.xctpspwj,
- d.gxsj,
- d.bz,
- d.yskzjbz,
- d.sjtbzt,
- d.tbsj,
- d.bjsfwb
- FROM ( SELECT row_number() OVER (PARTITION BY nl_jc_bjfx.bsm ORDER BY nl_jc_bjfx.tbsj DESC) AS rownum,
- nl_jc_bjfx.bsm,
- nl_jc_bjfx.bjbh,
- nl_jc_bjfx.bjdwwz,
- nl_jc_bjfx.xcpcry,
- nl_jc_bjfx.xcpcrylxdh,
- nl_jc_bjfx.ddxcsj,
- nl_jc_bjfx.xczkms,
- nl_jc_bjfx.zsry,
- nl_jc_bjfx.zsrylxdh,
- nl_jc_bjfx.zsrydw,
- nl_jc_bjfx.zsryfxjs,
- nl_jc_bjfx.xcryfxbg,
- nl_jc_bjfx.zsryfxsj,
- nl_jc_bjfx.fxnr,
- nl_jc_bjfx.xctpspwj,
- nl_jc_bjfx.gxsj,
- nl_jc_bjfx.bz,
- nl_jc_bjfx.yskzjbz,
- nl_jc_bjfx.sjtbzt,
- nl_jc_bjfx.tbsj,
- nl_jc_bjfx.bjsfwb
- FROM ztfbk_sjg.nl_jc_bjfx) d
- WHERE d.rownum = 1;
- ALTER TABLE "nl_jc_bjfx_view" OWNER TO "adq_sjg";
- CREATE VIEW "nl_jc_jcbj_view" AS SELECT d.rownum,
- d.bsm,
- d.bjmc,
- d.bjbh,
- d.dwbsm,
- d.sbbsm,
- d.jcbjzb,
- d.dqbjjb,
- d.ccbjsj,
- d.ccbjz,
- d.dqbjsj,
- d.dqbjz,
- d.ljbjpc,
- d.bjsfjc,
- d.bjjcsj,
- d.bjjcsm,
- d.bz,
- d.yskzjbz,
- d.sjtbzt,
- d.tbsj,
- d.bjjb,
- d.bjsj,
- d.bjz,
- d.qxyjqhmc,
- d.bjyz
- FROM ( SELECT row_number() OVER (PARTITION BY nl_jc_jcbj.bsm ORDER BY nl_jc_jcbj.tbsj DESC) AS rownum,
- nl_jc_jcbj.bsm,
- nl_jc_jcbj.bjmc,
- nl_jc_jcbj.bjbh,
- nl_jc_jcbj.dwbsm,
- nl_jc_jcbj.sbbsm,
- nl_jc_jcbj.jcbjzb,
- nl_jc_jcbj.dqbjjb,
- nl_jc_jcbj.ccbjsj,
- nl_jc_jcbj.ccbjz,
- nl_jc_jcbj.dqbjsj,
- nl_jc_jcbj.dqbjz,
- nl_jc_jcbj.ljbjpc,
- nl_jc_jcbj.bjsfjc,
- nl_jc_jcbj.bjjcsj,
- nl_jc_jcbj.bjjcsm,
- nl_jc_jcbj.bz,
- nl_jc_jcbj.yskzjbz,
- nl_jc_jcbj.sjtbzt,
- nl_jc_jcbj.tbsj,
- nl_jc_jcbj.bjjb,
- nl_jc_jcbj.bjsj,
- nl_jc_jcbj.bjz,
- nl_jc_jcbj.qxyjqhmc,
- nl_jc_jcbj.bjyz
- FROM ztfbk_sjg.nl_jc_jcbj) d
- WHERE d.rownum = 1;
- ALTER TABLE "nl_jc_jcbj_view" OWNER TO "adq_sjg";
|
