sql多字段的排序

select   *   from   tablename  
  order   by   fieldone   asc,fieldtwo   desc

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