postgis数据库，找出两个表同一字段有字段值有不一致的数据，然后找出的数据需要是唯一值

最新推荐文章于 2023-09-06 10:01:33 发布

GIS从业者

最新推荐文章于 2023-09-06 10:01:33 发布

阅读量355

点赞数

分类专栏： MySQL、postgresq、MongoDB、Redis 文章标签： postgis

本文链接：https://blog.csdn.net/yilvyangguang520/article/details/132606051

版权

MySQL、postgresq、MongoDB、Redis 专栏收录该内容

68 篇文章 3 订阅

订阅专栏

WITH combined_data AS (
    SELECT *
        FROM {standard_table_my}
        WHERE {map_y} > 0 AND {fieldname_my} IN 
              (SELECT {fieldname_my} 
              FROM {standard_table_my} 
              GROUP BY {fieldname_my} 
              HAVING COUNT(*) = 1)
    )
    SELECT *
         FROM combined_data  s
         LEFT JOIN {standard_table} e ON s.{fieldname_my}  = e.{fieldname} 
         WHERE e.{fieldname}  IS NULL OR s.{fieldname_my}  IS NULL OR s.{fieldname_my}  <> e.{fieldname} 
    '''.format(fieldname_my=fieldname_my,map_y=fieldname_lat,standard_table_my=standard_table_my,standard_table=standard_table,fieldname=fieldname)