Hi,
I have a table which basically looks like this:
create table (userid text, val integer, ts timestamp);
This table holds multiple values for users, timestamped for history
reasons.
Now I need to fetch the latest val for each userid to insert into a new
table (with about the same schema, except for uniqueness on userid).
I belive this should be a trivial task, but I'm experience total lack of
insight here...
Comments?
/Patrik Kudo