On 1/7/2011 5:37 PM, Martin.Engelschalk wrote: > Hi, > > i apologize beforehand if my post does not answer your question > directly. It seems to me that you may be missing a basic concept. > > Data in an SQL table is never sorted in itself. So, you can not sort a > table before you query it.
SQLite does give you the ability to sort by _rowid_ which returns the data in the manner that it was stored into the table. The idea of sorting the data before doing the query doesn't map to SQL very well... and is probably not required. Best Regards, Mohit. 1/7/2011 | 6:14 PM. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
