求SQL句子 在线等

[kalakala]

有这样一张表
id time flag
01 20040626 a
01 20040402 a
01 20031103 b
02 19800123 a
02 20040621 b
03 20040512 a

现在要选出的结果是
01 20040626 a
02 20040621 b
03 20040512 a
就是每个ID对应的最后（最大）的那个时间的flag。

[ocean9b]

select id,max(time) 'time',max(select flag from 表 where A.id=id,max(A.time)=time) 'flag' from 表 A group by id

[trampwind]

select * from tablename where id in(select max(id) from tablename group by id);

[pisces007]

select b.id,b.time,a.flag from yourtable a join
(select id,max(time) as time from yourtable group by id)b
on a.id=b.id and a.time=b.time

[trampwind]

不好意思写错了，select * from tablename where id||time in(select id||max(time) from tablename group by id);

[zqp1771]

select * from tablename where id+time in(select id+max(time) from tablename group by id)

[zheninchangjiang]

select * from yourtable a where [time]=(select max([time]) from yourtable where [id]=a.[id])

[ocean9b]

漏了个and
select id,max(time) 'time',max(select flag from 表 where A.id=id and max(A.time)=time) 'flag' from 表 A group by id

[kalakala]

谢谢