首页题目详情
以下SQL语句中，哪一个能正确统计每个城市的人口数量？
A.SELECT city, COUNT(*) FROM population_table GROUP BY city
B.SELECT city, COUNT(*) FROM population_table ORDER BY city
C.SELECT city, SUM(*) FROM population_table GROUP BY city
D.SELECT city, SUM(population) FROM population_table ORDER BY city
优质解答
答案
A
解析
COUNT(*)用于计数，GROUP BY city可对每个城市进行分组，因此A是正确选项。
数据库系统单选题中等AI生成