select number achievement
from chooseCourse
where courseNum = 1
order by achievement desc, number asc;错误提示:在排序依据列表中多次指定了某一列。排序依据列表中的列必须是唯一的。
我的chooseCourse表中各行是
number courseNume achievement
1 1 70
2 2 80
3 3 80
4 4 90
from chooseCourse
where courseNum = 1
order by achievement desc, number asc;错误提示:在排序依据列表中多次指定了某一列。排序依据列表中的列必须是唯一的。
我的chooseCourse表中各行是
number courseNume achievement
1 1 70
2 2 80
3 3 80
4 4 90
from chooseCourse
where courseNum = 1
order by achievement desc, number asc;
from chooseCourse
where courseNum = 1
order by achievement desc, [number] asc
from chooseCourse
where courseNum = 1
order by achievement desc, number asc;
from chooseCourse
where courseNum = 1
order by achievement desc, number asc; 缺个,号