我们想对表中的cost字段先做降序排序,再对sale字段做升序排序,下列sql写法正确的是()?
Aselect id,cost,sale from list 2 asc,3 desc;
Bselect id,cost,sale from list 2 desc,sale asc;
Cselect id,cost,sale from list 2 asc,sale desc;
Dselect id,cost,sale from list 2 asc,3 desc;