摘要：
按照面积最大筛选，行政区代码有重复 方法一： select "XZQDM","XZQMC","JZQ","MJ" from (select "XZQDM","XZQMC","JZQ","MJ",ROW_NUMBER() OVER (PARTITION by "XZQDM" ORDER BY "MJ" 阅读全文
摘要：
表名：hztj 字段名：edxzqhdm ,sdxzqhdm 1.查出某一列数据中重复的，以sdxzqhdm为例 select * from hztj a where (a.sdxzqhdm) in (select sdxzqhdm from hztj group by sdxzqhdm havin 阅读全文
