ID1 A 2022-03-02 <2021-06-23> 2022-03-05年1 A 2022-03-02 <2022-09>2022-03-062022-03-052022-03-05
你的问题还不完全清楚,但我猜你的意思是">日期在"strong>Odertime"之后或之前;,这样的东西:
select
id,
type,
sum(case when date > odertime then 1 else 0 end) as before,
sum(case when date < odertime then 1 else 0 end) as after
from test
group by
id,
type
请参阅sqlfiddle和示例