[thelist] SQL ORDER BY question

darren darren at web-bitch.co.uk
Thu Aug 22 10:33:01 CDT 2002


On Thursday, August 22, 2002 at 16:14, Jay Blanchard wrote:

JB> Which is last in, first out BY DATE. But doing ORDER BY logDate, ai DESC or
JB> ORDER BY ai, logDate DESC will not return the desired results either. I have
JB> searched the web for ORDER BY information, cannot find what I am looking
JB> for. I would prefer to handle this in the SQL instead of programatically.
JB> What am I (aside from 75% of my brain) missing?

wouldn't:

   ORDER BY logDate DESC, ai ASC

give you what you want??

hth,

darren




More information about the thelist mailing list