sql 如何查询用户登录表中所有用户的最后一次登录的id,时间，ip等记录

[wangjgdd]

表中有多个字段，id，name，ip，logintime我想取出表中所有用户最后一次登录的记录，请大侠帮忙，谢谢

[Shawn]

select * from tb a
where not exists(select 1 from tb where name = a.name and logintime > a.logintime)

[Shawn]

select b.* from
(select distinct name from tb) a
cross apply
(select top(1) * from tb where name = a.name order by logintime desc) b

[--小F--]

select * from tb where not exists(select 1 from tb where name=t.name and logintime>t.logintime)

[--小F--]

select
*
from
tb t
where
logintime=(select max(logintime) from tb where name=t.name)

[Truth is my belief]

CSDN里面的低手真够多的，上面各位写的SQL语句真2啊。