我要按照person表中的Department(部门)字段统计20033表中整型整型字段salary4(工资项目:实发工资)的总和,即求每个部门的实发工资总和,我用到了下面sql语句调试出错??为什么??
select person.Department, sum(distinct 20033.salary4) from 20033, where 20033.StafferID=person.StafferID group by person.Department
扑捉异常的错误为:语法错误 (操作符丢失) 在查询表达式 'sum(distinct 20033.salary4),另外如果执行成功返回记录集是不是有多少个部门就有多少个记录??
我用的是ado。
select person.Department, sum(distinct 20033.salary4) from 20033, where 20033.StafferID=person.StafferID group by person.Department
扑捉异常的错误为:语法错误 (操作符丢失) 在查询表达式 'sum(distinct 20033.salary4),另外如果执行成功返回记录集是不是有多少个部门就有多少个记录??
我用的是ado。
select person.Department, sum(distinct 20033.salary4) from 20033,person where 20033.StafferID=person.StafferID group by person.Department
select person.Department, sum([20033].salary)
from [20033],person
where [20033].StafferID = person.StafferID
group by person.Department执行成功返回记录集的的确是有多少个部门就有多少个记录
followed by:
select Department, sum(salary4) from statistic group by DepartmentAll is ok!