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.
