当前位置：网站首页>How to sort multiple fields and multiple values in sql statement

How to sort multiple fields and multiple values in sql statement

2022-08-05 02:47:00 【CSDN Q&A】

How to sort multiple fields and multiple values in SQL statement?The requirement is to query all the lists, and then sort them according to the origin and destination. I use the case when syntax to always report an error
sql statement as follows

 select swco.id,swco.order_type,swco.goods_type_id,swco.departure,swco.bounty,swco.goods_number,swco.goods_name,swco.destination,swco.goods_value,swco.goods_weight,swco.order_status,swco.end_time,swco.start_time from sys_we_chat_order swco where swco.deleted =0 order by case when departure ='Beijing' and destination ='Hengshui' then 'Beijing' when departure ='Beijing' then 'Hengshui' when destination ='Hengshui' then 'Hengshui', swco.create_time desc