这样也可以select job, case when count(score) % 2 =1 then count(score) div 2 + 1 when count(score) % 2 =0 then count(score) div 2 end as start, case when count(score) % 2 =1 then count(score) div 2 + 1 when count(score) % 2 =0 then count(score) div 2 + 1 end as end from grade group by job order by job
点赞

相关推荐

浩浩没烦恼:一二面加起来才一个小时? 我一面就一个小时多了
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务