select sum(BackSum),TrueName,Deptsid,DeptName,DeptsPName,max(BackTime) from Table group by TrueName,Deptsid,DeptName,DeptsPName order by max(BackTime) desc
select truename 销售人员,deptsid 部门ID,deptname 部门名称,deptspname 上级部门名称,sum(backsum)汇总的金额,MAX(backtime)最后一条的入款时间 from tb group by truename,deptsid,deptname,deptspname
select sum(BackSum) as BackSum ,TrueName ,Deptsid ,DeptName ,DeptsPName ,max(BackTime) as BackTime from Table group by TrueName ,Deptsid ,DeptName ,DeptsPName order by BackTime desc --注意这里的BackTime是在select子句中max(BackTime) 的别名。
select truename 销售人员,deptsid 部门ID,deptname 部门名称,deptspname 上级部门名称,sum(backsum)汇总的金额,MAX(backtime)最后一条的入款时间
from tb
group by truename,deptsid,deptname,deptspname
sum(BackSum) as BackSum
,TrueName
,Deptsid
,DeptName
,DeptsPName
,max(BackTime) as BackTime
from
Table
group by
TrueName
,Deptsid
,DeptName
,DeptsPName
order by
BackTime desc --注意这里的BackTime是在select子句中max(BackTime) 的别名。