跪求一条SQL语句

来源：百度知道 编辑：UC知道 时间：2024/06/06 23:27:51
有两张表，会员表 User(ID,Name),登录日志表Log（LogID,UserID,Time）.
请问如何用SQL语句查询出来所有的会员最近一次登录的 会员Name,时间Time？
请高手来指点一下。
谢谢了！！！！

SELECT USER.NAME, LOG.TIME
FROM USER, LOG
WHERE USER.ID = LOG.USERID
AND LOG.TIME = (SELECT MAX(TIME) FROM LOG GROUP BY TIME);

希望可以帮到你

sele a.name,b.time from 会员表 a,登录日志表 b where a.id=b.id
copy to c
sele name,max(time) from c group by name

select User.Name,Log.Time from User inner join Log on User.ID = Log.UserID order by Log.Time desc

select User.Name,Log.Time from User inner join Log on User.ID=Log.UserID where Log.Time in (select max(Time) from Log)

select Log.userID,User.Name,Log.Time from User inner join Log on User.ID = Log.UserID group by Log.userID order by Log.Time desc

select User.Name,Log.Time
From User INNER JOIN Log On Log.UserID=User.ID
Where User.ID IN (
Select top 1 UserID From Log x Where x.UserID=user.ID Order By x.Time DESC
)