sql - 如何同时选择两个属性

Question

我是 sql 新手，我想在表中搜索帐户 ID 和规则名称，但出现此错误

Expression"AccountID must appear in the GROUP BY clause or be used in aggregate function". 

我在count里加了，好像不对，怎么解决这个问题？

这是查询：

 SELECT AccountID, RuleName, COUNT(1) as COUNT
        FROM(**)
        WITH (***)
        GROUP BY RuleName;

标签： sql

Answer 1

AccountID正如错误所说，您还需要添加group by

SELECT AccountID, RuleName, COUNT(1) as COUNT
FROM tbl
GROUP BY AccountID, RuleName;