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 mysq
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
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 interva
What kind of erroneous results? How is the personal_id field defined?
The statement you have is syntacically correct so it must be something
in the data. If the personal_id is a numeric ID and you're storing it
as characters, this will sort differently than if you're sorting by
number. Rememb
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
