I have field1 where there are repeats, but I only want distinct rows returned. I also need to select field2 which is a timestamp of when the row was entered. If I do:
select distinct field1, field2 from table
it returns everything b/c it is giving me distinct based on both fields. Is there a way to get distinct for just field1 and yet return 2 fields?