Sub query help

[bumpert]

Hi i'm trying to do a sub-query and don't know how to do it.

i want to do a request like
select fingerprint, id, who from table where id = (select max(id) from the fingerprint of my query);

so how can i refer to the fingerprint in my query

if i do only the query, i got for example

ab 12 fred
fr 45 max
rt 24 max
fe 23 lewis
ab 45 lewis
fe 11 karine
ab 11 karine

with my sub query i want only one fingerprint of each but the one with the maximum id

something like:
ab 45 fred
fr 45 max
rt 24 max
fe 23 lewis


thx
sorry i have problem explain me sometimes in english