试题详情

MySQL中,按课程号升序,按成绩降序,对选课信息进行排序,正确的SQL语句是()。

Aselect * from sc order by cno, grade

Bselect * from sc order by cno, grade desc

Cselect * from sc order by cno asc, grade desc

Dselect * from sc order by cno asc desc, grade asc