> Your problem is that although SQL accepts the clauses written in the order > you wrote them in, the LIMIT clause is processed before the ORDER BY clause. > > Is that really true? I had always thought that the ORDER BY was processed first, though I admit I don't see anything authoritative either way. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] LIMIT doesn't return expected rows Tobias Ellinghaus
- Re: [sqlite] LIMIT doesn't return expected rows Simon Slavin
- Re: [sqlite] LIMIT doesn't return expected rows Eric Minbiole
- Re: [sqlite] LIMIT doesn't return expected ... Simon Slavin
- Re: [sqlite] LIMIT doesn't return expec... Dan Kennedy
- Re: [sqlite] LIMIT doesn't return expected rows Keith Medcalf
- Re: [sqlite] LIMIT doesn't return expected rows Tobias Ellinghaus
- Re: [sqlite] LIMIT doesn't return expected ... Keith Medcalf
- Re: [sqlite] LIMIT doesn't return expec... David Empson
- Re: [sqlite] LIMIT doesn't return ... David Empson
- Re: [sqlite] LIMIT doesn't ret... Keith Medcalf
- Re: [sqlite] LIMIT doesn't... Keith Medcalf
- Re: [sqlite] LIMIT doesn't... Keith Medcalf