MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: UNION and ORDER BY problem
Posted by: laptop alias
Date: March 14, 2011 04:40PM

It's weird, isn't it?

Try adding a LIMIT clause to the second query... 
SELECT * FROM comments ORDER BY rating DESC LIMIT 1
UNION
SELECT * FROM comments ORDER BY id DESC LIMIT 10000000

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
UNION and ORDER BY problem
David Nash
March 14, 2011 01:51PM
Re: UNION and ORDER BY problem
laptop alias
March 14, 2011 04:40PM
Re: UNION and ORDER BY problem
David Nash
March 14, 2011 09:28PM


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.