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