select * from tablename order by fieldone asc,fieldtwo desc
select * from tablename order by fieldone ,fieldtwo desc 是没有效果的