sql - 我想从最近生效日期的重复值中发送整条记录

Question

我想从最近生效日期的重复值中发送整个单条记录。下面是我使用连接从两个表中获取数据的查询

/** PULLS AREA ATTRIBUTES INTO SERVICENOW COUNTRY**/
SELECT g.CountryNm, o.CountryNm,o.effectivedt
FROM EDW.vwDimGeography g
JOIN EDW.vwDimOfficeLocation o
ON g.CountryNm=o.CountryNm
where g.countrynm != 'DOESNOTEXIST'
group by g.CountryNm,o.CountryNm,o.effectivedt

输出如下：

    +------------+------------+
    | CountryNm v|effectivedt |
    +------------+------------+
    |Afghanistan | Afghanistan| 
    |Afghanistan | Afghanistan| 
    |Afghanistan | Afghanistan|
    |   Aruba    |   Aruba    |
    |   Aruba    |   Aruba    |
    |   Aruba    |    Aruba   |
    |   Canada   |    Canada  |
    |    Canada  |   Canada   |
    |    Canada  |   Canada   |
    +------------+------------+
                       

但我想要输出，例如

   +------------+---------------------+------------+
   | CountryNm  | CountryNm v         |effectivedt |
   +------------+---------------------+------------+
   |Afghanistan | Afghanistan         | 30-09-2019 |
   |  Aruba     | Aruba               | 05-06-2021 |
   | Canada     | Canada              | 01-02-2020 |
   |+------------+---------------------+-----------+ 

标签： sql