ORACLE创建临时表保存相关数据

最新推荐文章于 2024-09-09 09:11:03 发布

wwlydkl

最新推荐文章于 2024-09-09 09:11:03 发布

阅读量321

点赞数 8

分类专栏：数据库文章标签： oracle 数据库

本文链接：https://blog.csdn.net/wwlydkl/article/details/135532253

版权

数据库专栏收录该内容

3 篇文章 0 订阅

订阅专栏

ORACLE
创建临时表，保存相关数据

create table T_FSA_Salarybacknew as 
select fid,fcreatorid,fcreatetime,flastupdateuserid,flastupdatetime,fcontrolunitid,fpersonid,fsocialnumber,fpositionsalarydji,fpositionsalarydxi,FbaseSalaryStart,fbaseSalaryGrade
,fbasesalary,fhousebstandard,fpsalarystandard,fcomhousefundb,fcomhousefund,femphousefundb,femphousefund,fcomplanno,fpersonplanno,fpreyearavgsalary,fannuitydate,fpreyearavgsocial,fhousefundbase,fbizdate,fiscurrent,fremark
,newbosid('') newwid from table a where a.fid in ( select fid from ( SELECT fid,FPERSONID,FBIZDATE, row_number() over (partition by FPERSONID order by FBIZDATE desc) as row_num
  FROM table )where row_num=1) and a.FPERSONID in (...)