On 19 Sep 2014, at 12:40am, Mark Halegua <phanto...@mindspring.com> wrote:
> Here are the commands: > > select * from contributors order by contrib_lname, contrib_fname; (works > properly) > select * from contributors order by contrib_lname, contrib_fname desc; (get > the same order > as above) Note that the DESC you provided above applies only to the first name. If you need DESC to apply to the last name too, you want select * from contributors order by contrib_lname DESC, contrib_fname desc > select * from contributors order by contrib_lname desc; (this works but > obviosiosly doesn't > sub-order the contrib_fname) If the above doesn't solve your problem, please ... tell us which version of SQLite you're using. give us a couple of INSERT commands which lead to results which are the wrong way around. It should be possible to demonstrate this with just two INSERTs. If it isn't, please try to give us as few as possible rows of data to demonstrate the problem. If this is a result retrieved by something in one of your programs, please try the same commands with one of the SQLite shell tools, downloadable from the SQLite site. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
