SELECT USERID,SUM(FENSHU)FENSHU,MAX(TIME) FROM TB GROUP BY USERID
SELECT T.userID,fenshu ,Time FROM (SELECT userID,sum(fenshu) as fenshu FORM TB GROUP BY userID)AS T JOIN (SELECT userID,max(Time ) as Time FROM TB GROUP BY userID)AS T1 ON T.userID=T1.userID
SELECT userid,sum(fenshu) as fenshu, (select MAX([time]) from USERTEXT as b where b.userID=a.userID) from USERTEXT as a group by userid
select userID ,sum(fenshu) as fenshu ,max(Time ) as Time from tb group by userID
SELECT T.userID,fenshu ,Time FROM
(SELECT userID,sum(fenshu) as fenshu FORM TB GROUP BY userID)AS T
JOIN
(SELECT userID,max(Time ) as Time FROM TB GROUP BY userID)AS T1
ON T.userID=T1.userID
(select MAX([time]) from USERTEXT as b where b.userID=a.userID) from USERTEXT as a
group by userid
userID
,sum(fenshu) as fenshu
,max(Time ) as Time
from
tb
group by
userID