MySQL Forums
Forum List  »  Quality Assurance

Re: 5.1.23-rc possible order by desc bug
Posted by: Mark Harburn
Date: February 18, 2008 07:10AM

SELECT tv.fromClientID AS clientID, tv.trackdate
FROM trackviews tv
LEFT JOIN mym p ON ( tv.fromClientID = p.clientID )
WHERE tv.clientID = 32
ORDER BY trackdate DESC
LIMIT 5

396951 1203236902
396726 1203169865
396492 1203157557
396326 1202945744
395826 1203239851

Is this what you were after?

Options: ReplyQuote


Subject
Views
Written By
Posted
4368
February 16, 2008 02:55AM
Re: 5.1.23-rc possible order by desc bug
2155
February 18, 2008 07:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.