SQL试题

用户表
id name age regTime

登录信息
id uid loginTime

购物信息
id uid productid time


1.查找最晚登录的用户名字、最晚登录时间
2.查找最后登录，并且已经购买物品的五个用户的名字、最后登录时间、购买时间



1.
SELECT * from (select u.name,l.logintime
from t_user u
left join t_record l on l.userid = u.id
order by l.loginTime desc
) where rownum<2

2.
select * from t_user u
inner join t_record l on l.userid = u.id and l.logintime = (select max(logintime) from t_record where userid= l.userid)
inner join t_cart s on s.userid = u.id
order by l.loginTime DESC