NCRE题库

登录注册
首页题库练习题目详情
数据库系统单选题中等

以下SQL语句中，哪一个能正确统计每个城市的人口数量？

ASELECT city, COUNT(*) FROM population_table GROUP BY city
BSELECT city, COUNT(*) FROM population_table ORDER BY city
CSELECT city, SUM(*) FROM population_table GROUP BY city
DSELECT city, SUM(population) FROM population_table ORDER BY city
上一题下一题