从高到低,没有问题,直接desc
SELECT * FROM t_bikes WHERE status=1 order by last_start_time desc
从低到高
SELECT * FROM t_bikes WHERE status=1 order by last_start_time is null, last_start_time ASC
从高到低,没有问题,直接desc
SELECT * FROM t_bikes WHERE status=1 order by last_start_time desc
SELECT * FROM t_bikes WHERE status=1 order by last_start_time is null, last_start_time ASC