I have a series of records - each is then replicated multiple times by date and then have andother column with either a value or null. each also has a unidue key based on the geom.

not every date has a value and thus in null.

what i need to search for is for each unique geom find the record that has the latest date with a value in the extra field.

needs to return one record per unique id

any help appreciated