ORDER子句中定义了多个字段,则按照字段的先后顺序排序:
select * from tablename order by column1 desc, column2 asc, column3 desc;
在column2中有'AAA','BBB'两种值。让AAA在前,BBB在后排序的情况:
方法一 select * from tablename order by column1 desc, case column2 when 'AAA' then 0 when 'BBB' then 1 end ,column3 desc;
方法二 select * from tablename order by column1 desc, CHARINDEX(column2,'AAA,BBB') , column3 desc
order by 多条件排序
最新推荐文章于 2024-03-28 10:15:18 发布