使用group by子句但显示所有记录 [英] using group by clause but show all records

问题描述

SELECT *, count(ProjPK)  FROM tblEmp
WHERE Half = 1
GROUP BY ProjPK

此SQL语句返回特定记录但我想使用上面的查询获得所有记录

但是还要显示每个记录的totalProjectMember

This SQL statement returning me specific records but I want to get all records using above query
but also show totalProjectMember with every record

推荐答案

尝试：

Try:

SELECT a.name, a.projId, b.totalProjectMember 
FROM tblEmp a
JOIN (SELECT projId, Count(*) AS totalProjectMember 
      FROM tblEmp 
      GROUP BY projId) b
ON a.projId = b.projId

这篇关于使用group by子句但显示所有记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！