多重查询的问题

[ltaixxx]

select workName,count(*)
(select count(*) from works where createTime between DATEADD(hh,-1,getdate()) and getdate() and workName=workName) as h1
from works group by workName

这个h1字段 是表述 在某一时间段内的各个员工完成数量(分组查询的) 后面那个 and workName=workName 是不成立的， 为了实现这个目的， 后面的where语句该怎么正确加呢
求大神教下

[小生我怕怕]

SELECT workName ,COUNT(1) ,SUM(CASE WHEN createTime between DATEADD(hh,-1,getdate()) and getdate() THEN 1 ELSE 0 END)h1 FROM works GROUP BY workName

[薛定谔的DBA]

--原来的语句，子查询加别名
select workName,count(*)
(select count(*) as [count] --这里加别名
from works 


--或者改为这样
select workName
,SUM(CASE WHEN createTime between DATEADD(hh,-1,getdate()) and getdate() THEN 1 ELSE 0 END) AS [count]
from works  
GROUP BY workName

[还在加载中灬]

SELECT workName,COUNT(1)h1
FROM works
WHERE createTime between DATEADD(hh,-1,getdate()) and getdate()
GROUP BY ALL workName

[还在加载中灬]

没太明白你的意思，你看下哪个是你要的

SELECT workName
	,COUNT(1)
	,SUM(CASE WHEN createTime between DATEADD(hh,-1,getdate()) and getdate() THEN 1 ELSE 0 END)h1
FROM works
GROUP BY workName

[0808xyj]

SELECT workName,SUM(CASE WHEN createTime between DATEADD(hh,-1,getdate()) and getdate() THEN 1 ELSE 0 END) countNum
FROM works
GROUP BY workName

[shoppo0505]

select workName,count(*) (select count(*) from works where createTime between DATEADD(hh,-1,getdate()) and getdate()) as h1 from works where works.workName= h1.workName group by works.workName