0
has a sequence of numbers 1 to 20 I would like to know if you have the correct number sequence for example:
1,2,3,4,5,6,7,8,9,10,11...
like this query select * from table order by numero asc;
he takes like this:
1,10,11,12,13,14,15,16,17,18,19,2,20...
has a way to get the first sequence I showed above using the order by
I tried to use a field for the order by didn’t work
The best thing would be to arrange the column for the right type. If it’s just numbers, it shouldn’t be CHAR/VARCHAR.
– Bacco
The column that has this sequence of numbers is in the numeric type?
– RXSD