MySQL Forums
Forum List  »  Newbie

Re: Question about LIMIT
Posted by: Rick James
Date: December 29, 2010 09:42AM

If you have the _same_ subquery 4 times, consider doing:
CREATE TEMPORARY TABLE tmp SELECT ... that subquery ...;
Then using `tmp` in the 4 places. Probably it would be:
( SELECT * from tmp ) as ...,



Edited 1 time(s). Last edit at 12/29/2010 09:43AM by Rick James.

Options: ReplyQuote


Subject
Written By
Posted
December 22, 2010 07:59AM
December 22, 2010 08:41AM
December 22, 2010 08:50AM
December 22, 2010 10:47AM
December 22, 2010 03:05PM
December 22, 2010 03:16PM
December 28, 2010 08:06AM
December 22, 2010 04:38PM
December 28, 2010 08:08AM
December 28, 2010 03:23PM
December 29, 2010 08:26AM
December 29, 2010 08:53AM
Re: Question about LIMIT
December 29, 2010 09:42AM
December 29, 2010 09:55AM


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.