我有一个Access 2010数据库是/否字段居住在城市范围或在周边县。我编写了一个SQL查询来计算每个类别中有多少人。如何将输出表中的行名从Yes/No更改为"居住在城市"one_answers"居住在县"?
SELECT Person.ResideCity, Count(*) AS [Count]
FROM Person
GROUP BY Person.ResideCity;
ResideCity Count
Yes 10
No 23
您可以使用IIF
语句来完成此操作。Yes/No字段是返回-1,否返回0。如果需要按此字段分组,则需要在GROUP BY
子句中使用完整的表达式:
SELECT IIF(Person.ResideCity = -1, "Reside In City", "Reside In County") As ResideCity
, Count(*) AS [Count]
FROM Person
GROUP BY IIF(Person.ResideCity = -1, "Reside In City", "Reside In County");