如何根据一行的条件检索历史数据

Question

我有一个表historical_data

column_aw1<1>

ID	日期	column-b
1	2011-10-01
1	2011-11-01	w
1	2011-09-01	a	a1
2	2011-01-12
2	2011-02-01
3	2011-11-01	s

使用QUALIFY:

SELECT *
FROM historical_data
QUALIFY MAX(date) OVER(PARTITION BY id) >= '2011-11-01'::DATE;