mysql - getting the last record of duplicate records

[myanavrin]

Hi to all,

How can i get the last record. Example: i have record with the same value in firstname. Now I want to get the value of the last inserted record. Hope it make sense.

Thanks!!!

[chazzy]

use max(whatever column it is) ?