存储过程中Group By的问题

Question

现在下面的代码按employeeid 分组

select   
    COUNT(employeelog.employeeid) as empVisit,  
    employeelog.employeeid as employeeID
into 
    #tempdr
from 
    Filteredps_employeelog as employeelog 
where 
    employeelog.ps_employeetypename in (@employeevisit, @empfamvisit)
group by   
    employeelog.employeeid

我想按admissionid分组。当我按以下方式尝试时，未返回预期结果。这是按admissionid分组的正确方式吗？

select  
    COUNT(employeelog.admissionid) as empadmission
into 
    #tempdr
from 
    Filteredps_employeelog as employeelog 
where 
    employeelog.ps_employeetypename in (@employeevisit, @empfamvisit)
group by   
    employeelog.admissionid

感谢

Answer 1

所以，您需要获得具有相同admissionid的员工数量，对吗？

这样更改您的查询。。

select employeelog.admissionid,COUNT(employeelog.employeeid) as empadmission
          into #tempdr
          from Filteredps_employeelog as  employeelog 
          where employeelog.ps_employeetypename in(@employeevisit ,@empfamvisit)
       group by   employeelog.admissionid,employeelog.employeeid

编辑：

如果你只想每个的admissionid计数，试试这个

select employeelog.admissionid,COUNT(employeelog.admissionid) as empadmission
      into #tempdr
      from Filteredps_employeelog as  employeelog 
      where employeelog.ps_employeetypename in(@employeevisit ,@empfamvisit)
   group by   employeelog.admissionid