Re: [SQL] Different order by behaviour depending on where clause?

Hi Phil, Thanks for your reply. On 28/10/11 23:25, Phil Couling wrote: > Hi Jan > > It is my understanding that a select query without "order by" has an > undefined order. > Though I'm sure you understand the dangers of using something which is > undefined, I'm going reiterate them here: I thin

Re: [SQL] optimize self-join query

Thanks to everyone for all the thoughtful responses. They have been incredibly helpful. Ended up optimizing per Lee, and creating buckets per Tom. Thanks again. On Oct 25, 2011, at 2:37 PM, Ty Busby wrote: I have a table that stores a very large starting number called epc_start_numeric and a