17,086
社区成员
发帖
与我相关
我的任务
分享
SQL>
SQL> with t as
2 (select '1' userid, '张三' name
3 from dual
4 union all
5 select '2' userid, '张四' name
6 from dual
7 union all
8 select '2' userid, '李四' name
9 from dual
10 union all
11 select '' userid, '张五' name
12 from dual
13 union all
14 select '' userid, '李五' name from dual)
15 select *
16 from t
17 where t.name like '张%'
18 or userid is null
19 /
USERID NAME
------ ----
1 张三
2 张四
张五
李五
SQL>