StarRocks 支持在select 中定义变量吗?
像这样的语句:
select recordDate,temperature,case when temperature > 15 or @startdate is not null then
ifnull(@startdate,recordDate) end as d,
@startdate:=case when temperature > 15 then ifnull(@startdate,recordDate) end as s
FROM yyh.weather ;