MySQL Forums
Forum List  »  Newbie

ORDER BY votes then DATE
Posted by: zeid haddadin
Date: October 12, 2008 11:53AM

Hi all,

I need to write an SQL query so that I can show data sorted like this:

If the field (votes) has a value > 0 then put these records at first (ORDER BY votes), then other records are ordered by date entered such as the latest is on top.

Thanks in advance,
zeid

Options: ReplyQuote


Subject
Written By
Posted
ORDER BY votes then DATE
October 12, 2008 11:53AM
October 12, 2008 12:11PM


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.