SQL----查询某一列字段有重复的而另一列值最大的所有数据

按照面积最大筛选，行政区代码有重复
方法一：
select "XZQDM","XZQMC","JZQ","MJ"
from
(select "XZQDM","XZQMC","JZQ","MJ",ROW_NUMBER() OVER (PARTITION by "XZQDM" ORDER BY "MJ" DESC) num
from "表名（假如是XZQ）"
) t
where t.num=1

方法二：
select "XZQDM","XZQMC","JZQ","MJ" from "XZQ"
where "MJ" in (select max("MJ") from "XZQ" group by "XZQ")
order by "XZQDM"