A Taylor wrote: > howdy all, > I was wondering if you could help me, I have a perl script that executes a > SQL statement: > > 'SELECT prop_rank FROM main ORDER BY prop_rank DESC' > > This returns many records but all i am interested in is the highest rank > hence the 'ORDER BY prop_rank DESC'.
use: SELECT prop_rank FROM main ORDER BY prop_rank DESC LIMIT 1 if you are using a mysql database. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
