At 8:39 -0600 2/1/02, Gerald Clark wrote: >Is it a character field? >If it is it will be an ascii sort, not a numeric sort. >Try: >select personal_id+1 as id from Emp_table order by id desc
personal_id+0 might be a bit better. > >Vishakha Mali_Wagh wrote: > >>Hi all, >> >>I have been using mysql since long time. But suddenly I noticed >>that, there is no function for sorting intervalues from the tabel. >>Clarifying more.... >>If I have a set of employee numbers and i need to sort them in >>descending order, I found that it gives erroneous results. >>The query is: >>select personal_id from Emp_table order by personal_id DESC >> >> >>Am I missing something or do i need to write the query differently? >>Please help. >>Regards, >>-vishakha. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
