worker(workerno ,workername,workersex,workerbirthday,partymember,timetowork,departno,)
职工号,姓名,性别,出生日期,党员否,参加工作时间,部门号
显示各部门的党员人数
USE factory
select departno as '部门号',
partymemberno as'党员人数'
from worker
group by departno
having count(*)='1'
消息 207,级别 16,状态 1,第 3 行
列名 'partymemberno' 无效。
为什么啊?请高手指教!
职工号,姓名,性别,出生日期,党员否,参加工作时间,部门号
显示各部门的党员人数
USE factory
select departno as '部门号',
partymemberno as'党员人数'
from worker
group by departno
having count(*)='1'
消息 207,级别 16,状态 1,第 3 行
列名 'partymemberno' 无效。
为什么啊?请高手指教!
go
select departno as '部门号',
partymemberno as'党员人数'
from worker
group by departno
having count(*)=1
你的表worker里好象只有partymember 而没有partymemberno吧
go
select departno as '部门号',
count(1) as'党员人数'
from worker
group by departno
having count(*)=1
select departno as '部门号',
partymemberno as'党员人数'
from worker
group by departno,partymemberno
having count(*)='1'