我想在一个视图中进行一个COUNT值的统计同时还要查询其他的列的值请问该怎么实现?下面是我自己写的一个查询语句.
select StaffName,StaffId,Office,DeptName,GroupNo,Mobile,Email,LoginName,CompPhone,ExtNo,JoinDate,LineCode,Picture_small,Picture_big ,count(CustomerName) as n from v_staff
...全文
1242打赏收藏
视图中查询的问题!
我想在一个视图中进行一个COUNT值的统计同时还要查询其他的列的值请问该怎么实现?下面是我自己写的一个查询语句. select StaffName,StaffId,Office,DeptName,GroupNo,Mobile,Email,LoginName,CompPhone,ExtNo,JoinDate,LineCode,Picture_small,Picture_big ,count(CustomerName) as n from v_staff
select
StaffName,StaffId,Office,DeptName,GroupNo,Mobile,Email,LoginName,CompPhone,ExtNo,JoinDate,LineCode,Picture_small,Picture_big ,count(CustomerName) as n
from v_staff Group By StaffName,StaffId,Office,DeptName,GroupNo,Mobile,Email,LoginName,CompPhone,ExtNo,JoinDate,LineCode,Picture_small,Picture_big