I have a table that is a set of responses to questions. Each record is stamped with a GUID to identify each record as being part of a set. So if I do
select distinct GUID from table1
I get a list of unique GUID's. But I want this ordered by the field Entered (entered date/time) I can't do this:
select distinct guid,entered from table1 order by entered
cause the sets are no longer distinct if I include 'Entered'. How can I get the query to return data that is also not distinct like the entered date for each 'GUID distinct' record it returns?