如果查询的select子句为select A,B,C*D ，则不能使用的group by子句是（C）。A. group by AB. group by A,BC. group by A,B,C*DD. group by A,B,C,D
A: group by A
B: group by A,B
C: group by A,B,C*D
D: group by A,B,C,D
A: group by A
B: group by A,B
C: group by A,B,C*D
D: group by A,B,C,D
举一反三
- 如果查询的select子句为select A,B,C*D ,则不能使用的group by子句是()。 A: group by A B: group by A,B C: group by A,B,C*D D: group by A,B,C,D
- 关于查询语句的SELECT子句为SELECT A,B,C*D,则可以使用的GROUP By子句是______。 A: GROUP BY A B: GROUP BY A,B C: GROUP BY A,B,C*D D: GROUP BY A,B,C+D
- 把查询语句的各个子句按执行的先后顺序排列，正确的是( ) 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
- 关于查询语句的SELECT子句为SELECT A,B,C *D,则不能使用的GROUP B子句是（ ）
- 以下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