sql 易错点（重点）

最新推荐文章于 2023-08-02 13:50:25 发布

longlovefilm

最新推荐文章于 2023-08-02 13:50:25 发布

阅读量232

点赞数

分类专栏： sql 文章标签： sql

本文链接：https://blog.csdn.net/longlovefilm/article/details/120531279

版权

sql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

with t1 as
(
  select null as f1, 21 as f2
  union all
  select 1 as f1, 22 as f2
  union all
  select 11 as f1, 23 as f2
)
select * from t1 where f1 <> 1

with t1 as (
        select null as f1,
               21 as f2
     union all select 1 as f1,
               22 as f2
     union all select 11 as f1,
               23 as f2
       ) select *
  from t1
 where f1 <> 1
    or f1 is null

二：

select 
    *
from
table1 t1 
left join (
    table2
 ) t8 on t1.back_cate0_id = t8.back_cate0_id
    and t1.back_cate1_id = t8.back_cate1_id
    and coalesce(t1.back_cate2_id,'null_value') = coalesce(t8.back_cate2_id,'null_value')
    and t1.province_id = t8.province_id
    and t1.city_id = t8.city_id

一定要注意null 的数值是关联不上的，如果不写
and coalesce(t1.back_cate2_id,'null_value') = coalesce(t8.back_cate2_id,'null_value')
就会关联的时候少数值

三