选项
A.
SELECT * FROM tbl_student ORDER BY stu_id ASC
B.
SELECT * FROM tbl_student ORDER BY stu_id DESC;
C.
SELECT * FROM tbl_student stu_id ORDER BY ASC;
D.
SELECT * FROM tbl_student stu_id ORDER BY DESC;
正确答案:
名词解析
基本语法,ASC为升序,DESC为降序,ORDER BY后面必须跟上要排序的属性名,B为降序排列,C、D语法错误。答案A。