![1655192483277230.png image.png](/upload/wenda/20220614/1655192483277230.png)
不过这种情况最好用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
![1655193545405235.png image.png](/upload/wenda/20220614/1655193545405235.png)