select * from a order by code, name desc; 相当于 select * from a order by code asc, name desc
原文:http://blog.csdn.net/xlxxcc/article/details/52250963