请教一条SQL语句

[orient_fc]

我的表结构:USERID, PAGECOUNT, GETDATE
要按USERID分组查询.
查询此表中GETDATE最大的记录对应的PAGECOUNT的值,而且按USERID分组
比如:
USERID PAGECOUNT GETDATE
1 100 2003/01/01
1 200 2003/01/02
2 200 2004/01/01
2 400 2004/01/02
3 800 2005/01/01
3 1000 2005/01/02

需要的查询结果:
USERID PAGECOUNT GETDATE
1 200 2003/01/02
2 400 2004/01/02
3 1000 2005/01/02

[jiezhi]

select USERID,max(PAGECOUNT),max(GETDATE) from a group by USERID

[zjcxc]

select USERID,max(PAGECOUNT),max(GETDATE) from a group by USERID

[zjcxc]

'上面的应该理解错了.

'正确的应该是:
select userid,pagecount,getdate from 表 a where getdate=(select max(getdate) from 表 where userid=a.userid)

[yoki]

select userid,pagecount,getdate from tablename a
where getdate=(select max(getdate) from 表 where userid=a.userid Group by userid)

[qdubit]

select userid,pagecount,getdate from table1 a where getdate=(select max(getdate) from table2 where userid=a.userid)