sql中特殊条件置顶排序
select
v.*,i.plate_no plateNo,i.pri_user_name priUserName,i.car_type carType
from vms_car_annual_verification v
LEFT JOIN vms_car_info i ON v.car_id = i.id
LEFT JOIN sys_user u ON v.pri_user_id = u.id
WHERE v.is_delete = ‘0’
and v.is_under_warranty = ‘0’
and DATE_ADD(CURDATE(),INTERVAL -2 YEAR)<=v.vi_date
ORDER BY CASE WHEN v.next_date <= DATE_ADD(CURDATE(),INTERVAL 3 MONTH)THEN 0 ELSE 1 END