oracle去掉重复数据

最新推荐文章于 2024-11-18 13:56:06 发布

原创最新推荐文章于 2024-11-18 13:56:06 发布 · 222 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql

sql 专栏收录该内容

1 篇文章

订阅专栏

select lpad(f.pernr_cp, 8, '0') emp_code,
       f.begda begindate,
       f.begda enddate,
       f.lgart salaryitem,
       f.time_in,
       f.*
  from osps.TI_OSPS_ALLOWANCE f
 where not exists (select 1
          from osps.TI_OSPS_ALLOWANCE t
         where t.time_in > f.time_in
           and t.pernr_cp = f.pernr_cp
           and t.begda = f.begda
           and t.lgart = f.lgart)
 order by 1 desc;