如何获取累积数据？我试图在SQL中获得以下水平，但没有得到期望的结果/Pyspark

Question

因此，<30 的铲斗值不会在 <60 等中显示。我怎样才能做到这一点

    case when DATEDIFF((to_date('2022-01-07', 'yyyy-MM-dd')),max(to_date((column), 'yyyy-MM-dd'))) between 0 and 29 then '<30' 
        when DATEDIFF((to_date('2022-01-07', 'yyyy-MM-dd')),max(to_date((column), 'yyyy-MM-dd'))) between 0 and 59 then '<60'
        when DATEDIFF((to_date('2022-01-07', 'yyyy-MM-dd')),max(to_date((column), 'yyyy-MM-dd'))) between 0 and 89 then '<90' 
        when DATEDIFF((to_date('2022-01-07', 'yyyy-MM-dd')),max(to_date((column), 'yyyy-MM-dd'))) between 0 and 179 then '<180' 
        when DATEDIFF((to_date('2022-01-07', 'yyyy-MM-dd')),max(to_date((column), 'yyyy-MM-dd'))) > 180 then '>180'
     end 
     else 'bad_date' 

Answer 1

只需更改您的条件之间

... between 0 and 29 then '<30'
... between 30 and 59 then '<60'
... between 60 and 89 then '<90'
... between 90 and 179 then '<180'
... > 180 then '>180'