以下按照姓名升序排列的是：（）
A: order by name asc
B: order by asc name
C: order by name desc
D: order by desc name
A: order by name asc
B: order by asc name
C: order by name desc
D: order by desc name
举一反三
- 输出公司的名称及id，以id的升序排列 A: SELECT name, id FROM job ORDER BY id ASC; B: SELECT name, id FROM job ORDER BY id DESC; C: SELECT name, id FROM job ORDER BY name DECS; D: SELECT name, id FROM job ORDER BY name ASC;
- 从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是： A: select name, age, score from student order by age desc , score; B: select name, age, score from student order by age , score asc; C: select name, age, score from student order by 2 desc , 3 asc; D: select name, age, score from student order by 1 desc , 2；
- 将查询结果按照升序排列的是（）。 A: ORDER BY DESC B: ORDER BY ASC C: GROUP BY DESC D: GROUP BY ASC
- 排序方式可以升序order by age asc，也可以降序 order by age desc。
- SQL查询语句中，查询结果需要根据stuid字段升序排序，以下写法正确的是（ ）。 A: order by stuid desc B: order by stuid asc C: order stuid asc D: by stuid asc