List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 1 2002 3:16pm
Subject:Re: problem sorting integer
View as plain text  
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.

Thread
problem sorting integerVishakha Mali_Wagh1 Feb
  • Re: problem sorting integerRon Beck1 Feb
  • Re: problem sorting integerGerald Clark1 Feb
    • Re: problem sorting integerPaul DuBois1 Feb