nayi_224的博客

逻辑删除

select distinct
	   t1.gdate,
	   first_value(t2.aver_price) over(order by t2.pub_date desc),
	   first_value(t2.id) over(order by t2.pub_date desc)
  from g t1, 
	   p t2
 where t1.gdate >= t2.pub_date

and 改成 or

自己的代码自己检查去，没人会去看你这一大坨代码的

select 名称,代码

  from tab1

connect by prior rowid = rowid

  and prior sys_guid() is not null

  and level <= 显示次数

select t1.*,
       sum(t1.ad) over(order by t1.order_by)
  from (     
select t1.*,
       case when lag(t1.this_pagename) over(order by t1.order_by) = t1.this_pagename then 0 else 1 end ad
  from tab1 t1
) t1

select t1.id,
       t1.name,
       t1.num
  from (
select t1.*,
       sum(t1.num) over(partition by t1.name order by t1.id) /
       sum(t1.num) over(partition by t1.name) per
  from tab1 t1
) t1
 where t1.per > 0.6

with tab1 as (
select 1 id, 'asd8753959\；addw123123213' a from dual 
union all select 2, 'WMX8753959, 编号:/addw-123123213  WAA2323131323' from dual 
)
, tab2 as(
select t1.*,
       regexp_replace(regexp_replace(t1.a, '[^a-zA-Z0-9\-]|\\', ';'), ';+', ';') b
  from tab1 t1
)
select t1.*,
       regexp_substr(t1.b, '[a-zA-Z0-9\-]+', 1, level)
  from tab2 t1
connect by prior id = id
   and level <= regexp_count(t1.b, ';') + 1
   and prior sys_guid() is not null
;