2011/7/1 Mohit Sindhwani <[email protected]>
> 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. > > Isn't it possible to use a view for that? Alessandro _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
