Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Distinct field selection?
mikerexx, your code worked perfectly! (after a minor addition to add a Time max after the Date max) Thank you so very much! -
Distinct field selection?
Situation: I have a table structured as such: ticket_id date time field2 What I am trying to do is take the table and strip out all duplicates of ticket_id, keeping the most recent according to the time field. Of course, I can do a SELECT DISTINCT on just the ticket_id field, and I get just...
