Simon, that resolved it. I didn't know you needed to put the desc with both columns.
It means another table I had thought was properly ordered wasn't. Thank you. Mark On Friday, September 19, 2014 12:50:57 AM Simon Slavin wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users