如果查询的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: 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子句是(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
- 关于查询语句的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 B子句是( )
- 把查询语句的各个子句按执行的先后顺序排列,正确的是( ) 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查询中有where、having、order by和group by子句时,应该书写在最后的是( ) A: where子句 B: having子句 C: order by子句 D: group by子句