-- 根据字段的不同值进行升序和降序排序( SELECT * FROM t_customer_list WHERE customer = 1 ORDER BY CREATE_DATE DESC ) UNION ALL( SELECT * FROM t_customer_list WHERE supplier = 1 ORDER BY CREATE_DATE ASC );SELECT* FROMt_customer_list ORDER BYCASEWHEN supplier = 1 THENCREATE_DATE END DESC,CASEWHEN customer = 1 THENCREATE_DATE END ASC;
如果觉得《MySQL 根据字段的不同值进行升序和降序排序》对你有帮助,请点赞、收藏,并留下你的观点哦!