這個(gè)題怎么做呀,求大佬解答
全部評(píng)論
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)贊 評(píng)論 收藏
分享
03-25 20:47
華中科技大學(xué) golang 點(diǎn)贊 評(píng)論 收藏
分享
03-20 11:44
門頭溝學(xué)院 嵌入式軟件開發(fā) 點(diǎn)贊 評(píng)論 收藏
分享