5
SQL消费表中查找所有用户最后一条消费记录
BussnissLogs表中字段BussnissLogsID(消费流水ID),UserID(用户ID),HappeningTime(消费时间) 这个SQL应该怎么写呢?
BussnissLogs表中字段BussnissLogsID(消费流水ID),UserID(用户ID),HappeningTime(消费时间) 这个SQL应该怎么写呢?
select a.* from BussnissLogs a,(select userid,max(HappeningTime) HappeningTime
from BussissLogs
group by UserID) b
where a.userid = b.userid
and a.HappeningTime = b.HappeningTime
假设表为T_ClientConsuemLog 字段包含:F_ClientConsumeID,F_ClientID,F_ClientConsumeDate,F_ClientConsumeMon发布于2012-07-12 11:29 最佳答案是同一个F_ClientID有很多条把?
select * from T_ClientConsuemLog,(
select max(F_ClientConsumeID) as fid from T_ClientConsuemLog group by F_ClientID) tablea
where T_ClientConsuemLog. F_ClientConsumeID = tablea.fid