下列查询语句能够正确执行的是()。 A: SELECT c1,c2,MAX(c3) FROM table_name HAVING c1>;1 B: SELECT c1,c2,MAX(c3) FROM table_name GROUP BY c1 HAVING c2>;1 C: SELECT c1,c2,MAX(c3) FROM table_name GROUP BY c1,c2 HAVING c2>;1 D: SELECT c1,c2,MAX(c3) FROM table_name WHERE c1>;1 GROUP BY c2 HAVING c2>;1

公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！

2022-05-31

下列查询语句能够正确执行的是()。 A: SELECT c1,c2,MAX(c3) FROM table_name HAVING c1>;1 B: SELECT c1,c2,MAX(c3) FROM table_name GROUP BY c1 HAVING c2>;1 C: SELECT c1,c2,MAX(c3) FROM table_name GROUP BY c1,c2 HAVING c2>;1 D: SELECT c1,c2,MAX(c3) FROM table_name WHERE c1>;1 GROUP BY c2 HAVING c2>;1

下列查询语句能够正确执行的是()。
A: SELECT c1,c2,MAX(c3) FROM table_name HAVING c1>;1
B: SELECT c1,c2,MAX(c3) FROM table_name GROUP BY c1 HAVING c2>;1
C: SELECT c1,c2,MAX(c3) FROM table_name GROUP BY c1,c2 HAVING c2>;1
D: SELECT c1,c2,MAX(c3) FROM table_name WHERE c1>;1 GROUP BY c2 HAVING c2>;1

答案：

查看

举一反三