这段sql里面怎么把date_day取最小的一条:select
date_day,
workshop,
production,
plan,
rate
from(
select
toDate(partition_date) as date_day,
case when operation in('1ZM','1FM') then '电极'
when operation = '1HJ1' then '装配'
when operation = '1FZ' then '化成' end as workshop,
sum(toFloat64(qty)) as production,
'0' as plan,
'0' as rate
from
(
SELECT action_code,partition_date, sfc,operation, item, qty,shop_order_bo,resrce,
row_number() over (partition by operation ,sfc,action_code order by created_timestamp desc) as row_num
FROM chuz_ods.ods_mes_activity_log_all
where 1=1
and change_stamp IS NULL
and action_code = 'COMPLETE'
and partition_date >= cast(concat(toString(today()-1),' 07:00:00.000') as DateTime64)
and partition_date <= cast(concat(toString(today()),' 07:00:00.000') as DateTime64)
and operation in ('1ZM','1FM','1HJ1','1FZ')
group by action_code,partition_date, sfc,operation, item, qty,shop_order_bo,resrce,created_timestamp
)
where 1=1
and row_num =1
group by
toDate(partition_date),
case when operation in('1ZM','1FM') then '电极'
when operation = '1HJ1' then '装配'
when operation = '1FZ' then '化成' end as workshop
)
where 1=1