请教这个SQL语句该怎么写?用DISTINCT不行啊!

[ninthpoint]

有一个表名为COUNT
字段如下:
session logonTime
11111 2003-11-12
11111 2003-02-11
22222 2003-11-02
.......
要求写一个SQL语句,列出session字段重复的logonTime最近的所有记录

谢谢

[蓝天]

select session, max( logonTime ) from yourtable group by session

[lvfengrong]

select session, max( logonTime) from [count] group by session

[ninthpoint]

忘记了再说明一写,表中还有其他的字段也要查询出来
session logonTime lastMoulel .....
11111 2003-11-12 首页 .....
11111 2003-02-11 用户中心 .....
22222 2003-11-02 BBS .....
......
要求写一个SQL语句,列出session字段重复的logonTime最近的所有记录,不能所有的都用MAX(吧)
谢谢

[蓝天]

select * from yourtable t1 where logonTime = (select max(logonTime ) from yourtable t2 where t1.session=t2.session)

[jin888888]

select distinct * from table As A where logonTime=(select max(logontime) from table where session=a.session)