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

2011-10-28 Thread Phil Couling
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: In general you should never rely on something which is undefined. Attempting to investigate

Re: [SQL] optimize self-join query

2011-10-28 Thread Harald Fuchs
In article , Ty Busby writes: > I have a table that stores a very large starting number called > epc_start_numeric and a quantity. I've apparently built the most > inefficient query possible for doing the job I need: find out if any > records overlap. Imagine the epc_start_numeric + quantity >