A: 必须按from…where…group…having…order顺序书写,不可以调换顺序
B: 按from…where…group…having…order顺序书写,除from外,其它可以省略
C: from、where、group、having、order各命令的顺序可以前后调整
D: from、where、group、having、order各命令,除from必须在前,其它顺序可以前后调整
举一反三
- 以下SQL子句的撰写顺序表达正确的是: A: SELECT、FROM、WHERE、GROUP BY、HAVING、ORDER BY B: SELECT、FROM、WHERE、HAVING、GROUP BY、ORDER BY C: SELECT、FROM、WHERE、ORDER BY、HAVING、GROUP BY D: SELECT、FROM、ORDER BY、WHERE、GROUP BY、HAVING
- 在SQL查询语句中以下正确的子句顺序是? A: WHERE --- GROUP BY --- HAVING --- ORDER BY B: GROUP BY --- HAVING --- ORDER BY --- WHERE C: WHERE --- HAVING --- GROUP BY --- ORDER BY D: GROUP BY --- ORDER BY --- HAVING --- WHERE
- 把查询语句的各个子句按执行的先后顺序排列,正确的是( ) A: FROM→WHERE→GROUP BY→SELECT→ORDER BY B: SELECT→FROM→WHERE→GROUP BY→ORDER BY C: WHERE→FROM→SELECT→GROUP BY→ORDER BY D: FROM→WHERE→SELECT→ORDER BY→GROUP BY
- 标准SQL基本查询模块的结构是______。 A: SELECT…FROM…ORDER BY B: SELECT…1WHERE…GROUP BY C: SELECT…WHERE…HAVING D: SELECT…FROM…WHERE
- SQL查询命令的结构是:SELECT…FROM…WHERE…GROUP BY…HAVING…ORDER BY…其中,使用HAVING时必须配合使用的短语是( )。 A.FROM B.GROUP BY C.WHERE D.ORDER BY
内容
- 0
SQL查询的Select语句中,Having必须和下列( )一起使用。 A: Where B: From C: Group By D: Order By
- 1
若要求“查询选修了3门以上课程的学生的学号”,正确的SQL语句是( ) A: SELECT sNo FROM SC GROUP BY sNo WHERE COUNT(*)> 3 B: SELECT sNo FROM SC GROUP BY sNo HAVING COUNT(*)> 3 C: SELECT sNo FROM SC ORDER BY sNo WHERE COUNT(*)> 3 D: SELECT sNo FROM SC ORDER BY sNo HAVING COUNT(*)> 3
- 2
SQL查询命令的结构是SELECT…FROM…WHERE… GROUP BY…HAVING…ORDER BY…,其中指定查询条件的短语是 A.SELECT B.FROM C.WHERE D.ORDER BY
- 3
SQL语法中,用查询语句时,以下执行顺序正确的是? A: from、where、groupby、select、distinct*、having、orderby B: from、where、groupby、having、select、distinct*、orderby C: from、groupby、where、select、distinct*、having、orderby D: from、where、groupby、select、distinct*、orderby、having
- 4
下列各题A)、B)、C)、D)四个选项中,只有一个选项是正确的。 标准SQL基本查询模块的结构是______。 A: SELECT…FROM…ORDER BY B: SELECT…WHERE…GROUP BY C: SELECT…WHERE…HAVING D: SELECT…FROM…WHERE