试题详情

我们想对表中的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;