select
(case when avg_play_duration/60 >= 1
then concat(round(avg_play_duration/60,2) ,'m')
else concat(round(avg_play_duration) ,'s') end) as avg_play_duration from table
case when concat() round()
于 2024-11-15 11:56:08 首次发布
select
(case when avg_play_duration/60 >= 1
then concat(round(avg_play_duration/60,2) ,'m')
else concat(round(avg_play_duration) ,'s') end) as avg_play_duration from table