select * from test order by 字段1,字段2 desc; 原因:第一个字段也要加desc 解决方案: select * from test order by 字段1 desc,字段2 desc;