我正在try 使用以下查询提供最近的日期:
select id, amount, yearmonthday
from (
select
id,
amount,
yearmonthday,
row_number() OVER (PARTITION BY id ORDER BY try(date_parse(yearmonthday, '%Y-%m-%d'))) as row_num
from "db_raw"."table" ) ranked
where row_num = 1 and id = 1
但每次我运行查询时,都会得到不同的结果,而不是上次的日期
第一次 run ,带来了我想要的:
id | amount | yearmonthday |
---|---|---|
1 | 10000 | 20231213 |
如果我再次参选,会给我带来另一个结果:
id | amount | yearmonthday |
---|---|---|
1 | 9000 | 20230327 |