sql - 聚合函数和其他列

Question

SQL 查询是否可以返回一些普通列和一些聚合列？

喜欢:

Col_A | Col_B | SUM
------+-------+------
   5  |   6   |  7

Answer 1

您应该使用 group by statement .

The GROUP BY statement is used in conjunction with the aggregate functions to group the result-set by one or more columns.

例如:

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name

你可以看到一个完整的例子here .