mySql轮询排序，如图，排值班表，如何使用sql语句实现排序？

Question

如图，排值班表，如何使用sql语句实现排序？

Answer 1

select * from
(select t1.id-t2.min_id+1 as new_id,t1.name,t1.other
from pai_ban_biao t1
inner join (select min(id) as min_id,name from pai_ban_biao group by name )t2
on t1.name=t2.name
)t3
order by t3.new_id,t3.other

Answer 2

SELECT * from tablename ORDER BY other,id