from
(
select substr(name,1,instr(name,'/')-1) name from 表名 where name like '%/%'
union all
select name from 表名 where name not like '%/%'
) as t
是这样吗？你那个到底是左斜杠还是右斜杠？我都按是左写的
oracle如何获取"/"之前的字符并去除重复
from
(
select substr(name,1,instr(name,'/')-1) name from 表名 where name like '%/%'
union all
select name from 表名 where name not like '%/%'
) as t
