不过这种情况最好用SQL处理
SELECT 城市,max(数据时间) FROM TABLE GROUP BY 城市
-------------------
with A AS (
SELECT 'A' [A],'2022-05-01' [B]
UNION ALL
SELECT 'A' [A],'2022-05-07' [B]
UNION ALL
SELECT 'A' [A],'2022-06-08' [B]
UNION ALL
SELECT 'A' [A],'2022-06-09' [B]
UNION ALL
SELECT 'B' [A],'2022-06-08' [B]
UNION ALL
SELECT 'B' [A],'2022-06-09' [B]
UNION ALL
SELECT 'C' [A],'2022-05-01' [B]
UNION ALL
SELECT 'D' [A],'2022-05-01' [B]
)
SELECT A,LEFT(B,7) [S],MAX(B) FROM A GROUP BY A,LEFT(B,7) ORDER BY 1