antonio.collins (3/7/2008)

---

here's one solution:

select A.username, A.id

from your_table as A

join (select username, max(id) as max_id

from your_table...