51cto Linux 高级架构师
2022-11-24 21:05 作者:janet19961217 | 我要投稿
select
browse_second_num,
count(browse_second_num) launch_num,
case
when browse_second_num <![CDATA[ < ]]> 10 then '<10秒'
when browse_second_num <![CDATA[ >= ]]> 10 and browse_second_num <![CDATA[ <= ]]> 30 then '10秒-30秒'
when browse_second_num <![CDATA[ >= ]]> 31 and browse_second_num <![CDATA[ <= ]]> 60 then '31秒-2分'
else '>2分'
end browse_second_typefrom t_table
