题目内容

在 SELECT 语句中,用于将查询结果进行排序的关键字是。

A. HAVING
B. GROUP BY
C. WHERE
D. ORDER BY

查看答案
更多问题

下列选项中,用于过滤查询结果中重复行的关键字是

A. DISTINCT
B. HAVING
C. ORDER BY
D. LIMIT

当对字段进行排序时,默认采用的排序方式是

ASC
B. DESC
C. ESC
DSC

下列选项中,能够按照 score 由高到低显示 student 表中记录的 SQL 语句是

A. SELECT* FROM student ORDER BY score ;
B. SELECT* FROM student ORDER BY score ASC ;
C. SELECT * FROM student ORDER BY score DESC ;
D. SELECT* FROM student GROUP BY score DESC ;

在 SELECT 语句中,用于筛选行的关键字是

A. WHILE
B. GROUP BY
C. WHERE
D. HAVNG

答案查题题库