這個(gè)題怎么做呀,求大佬解答
全部評論
select
brand
,least(a.time_all,a.time_one)
from
(select
brand
,min(start_time) as start_min
,max(end_time) as end_min
,max(end_time)-min(start_time)+1 as time_one
,sum(end_time-start_time+1) as time_all
from t
group by
brand
) a
相關(guān)推薦
點(diǎn)贊 評論 收藏
分享
05-01 22:00
重慶城市職業(yè)學(xué)院 運(yùn)維工程師 點(diǎn)贊 評論 收藏
分享
點(diǎn)贊 評論 收藏
分享