SQL每个用户取1条记录

SQL每个用户取1条记录: SELECT * FROM table WHERE id IN( SELECT MAX(id) from table group by username )