Home > Archive > MySQL Server Forum > June 2005 > Distinct, Most Recent Sort









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Distinct, Most Recent Sort
Gary

2005-06-03, 8:23 pm

Does anyone know how to do a sort to find the most recent distinct records.

We have records with equipment, and activities the equipment was used for,
but I need a distinct list of where the equipment currently is, if I do a
distinct ...order by date, it will perform the distinct first, ahead of
ordering.

Thanks for your help.


Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com