mysql的sql查询写法问题

Question

mysql sql 写法

怎么使结果集增加一列，是sum（countName）的值

Answer 1

参考下述代码即可

select number,countName, id,sum(a.countName) as cn from (
SELECT
number,
count( NAME ) AS countName,sum( id ) as id
FROM
test
WHERE
adress ='1
GROUP BY number
) a