能否用一条SQL语句实现

[fangpeng2003]

表里有三个字段

id username content
1 tom aaa
2 jack bba
3 tom bbb
4 jack ccc
5 rose ddd
6 rose rara

我要得到这样的结果
id username content
3 tom bbb
4 jack ccc
6 rose rara

就是说要取到每个人最新的记录即可。

[progress99]

select username,max(id) as id,max(content) as content
from 你的表
group by username

[dlpseeyou]

select username,max(id) as id,max(content) as content
from 表 group by username

[victorycyz]

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

[leeboyan]

select * from table1 where id in(select max(id)as id from table1 group by username)

[playyuer]

select *
from 表 a
where id = (select max(id) from 表 where username = a.username )


select *
from 表 a
where not exists (select 1 from 表 where username = a.username and id > a.id)