求SQL语句，查询每名学生成绩的最新记要

求SQL语句，查询每名学生成绩的最新记录。
学号             姓名        语文      数学      英语      录入时间
21073          Jack         89         76          90         20100701
21098           Tom        90          89          77        20100701
21054           John        98         76           94        20100701
21067           Smith       89         94          85         20100701
21098            Tom        79          90          80        20110125
21054            John        99         90          65         20110125
21098            Tom        86           89         76         20120705

我想得到的结果是：
学号             姓名        语文      数学      英语      录入时间
21073          Jack         89         76          90         20100701
21067           Smith       89         94          85         20100701
21054            John        99         90          65         20110125
21098            Tom        86           89         76         20120705

请问SQL如何写？多谢！

------解决方案--------------------

select  b.*  from （
select  姓名 ,max(id)  from  表  group by  姓名 
） a  
left  outer join 表  b  on a.id=b.id
------解决方案--------------------

引用:

学号             姓名        语文      数学      英语      录入时间
21073          Jack         89         76          90         20100701
21098           Tom        90          89          77        20100701
21054           John        98         76           94        20100701
21067           Smith       89         94          85         20100701