有点晕了，大侠来帮我写这个SQL吧

[flashroom]

id team dotime
1 1 2004-4-4
2 2 2004-5-8
3 2 2004-8-9
4 1 2004-1-5
5 2 2004-5-9
6 1 2006-5-4

写条SQL得出每组中 DOTIME最大的ID。
结果应该是

id
6
3

帮帮忙啦，多谢

[dnel]

DOTIME的类型是什么啊

[yesterday2000]

select id
from tb a,(select team,max(dotime) as dotime from tb group by team) b
where a.team=b.team

[flashroom]

int int datetime

不好意思，忘了，呵呵

[zjcxc]

select id=max(id),b.team
from 表 a,(select team,dotime=max(dotime) from 表 group by team)b
where a.team=b.team and a.dotime=b.dotime
group by b.team

[flashroom]

多写楼上的

[zsforever]

select id , team , dotime from yourtable a where a.dotime = (select max(dotime) from yourtable b where a.team=b.team )