| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Boyd E. Hemphill | Date: | May 3 2004 5:39pm |
| Subject: | urban myth? | ||
| View as plain text | |||
My boss says that if you do a select statement against a table the result set always comes back in the same order. I say that this is a myth and that the result is random, except when some ordering is specified in the SQL statement. Who is right? Is this behavior specified by ANSI or ISO? Best Regards, Boyd E. Hemphill bhemphill@stripped Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688
| Thread | ||
|---|---|---|
| • Create table results in (errno: 121) | Tom Brown | 22 Apr |
| • Re: Create table results in (errno: 121) | Martijn Tonies | 22 Apr |
| • Re: Create table results in (errno: 121) | Tom Brown | 22 Apr |
| • Re: Create table results in (errno: 121) | Adam | 28 Apr |
| • urban myth? | Boyd E. Hemphill | 3 May |
| • Re: urban myth? | Peter J Milanese | 3 May |
| • Re: urban myth? | Daniel Clark | 3 May |
| • Re: urban myth? | Garth Webb | 3 May |
| • Re: urban myth? | Bob Ramsey | 3 May |
| • Re: urban myth? | Josh Trutwin | 3 May |
| • Re: urban myth? | Garth Webb | 3 May |
| • Re: urban myth? | Michael Stassen | 3 May |
| • RE: urban myth? | Boyd E. Hemphill | 3 May |
| • Re: urban myth? | Anders Karlsson | 3 May |
| • Re: urban myth? | Michael T. Babcock | 13 May |
| • Re: urban myth? | Josh Trutwin | 3 May |
| • Re: urban myth? | Jeremy Zawodny | 3 May |
| • Re: urban myth? | gerald_clark | 3 May |
| • Re: urban myth? | Peter J Milanese | 3 May |
| • Re: Create table results in (errno: 121) | beacker | 22 Apr |
| • RE: urban myth? | Mike Johnson | 3 May |
| • Re: urban myth? | Udikarni | 3 May |