I have a query ordered by column
:
select * from mytable order by column asc — sort table
column
type is varchar, so the output is:
1
10
100
11
12
13
How should I sort if I want them to sort by numeric value so the output is:
1
10
11
12
13
100
See Question&Answers more detail:os