When using Order By field having number doesnt work some time. Actually it tries to sort the fields considering them as string, so numbers 11,2,1,111,21,3 will be sorted like:
which is not desired, it should be:
To order the values as they should be, simply use the SQL ABS function.
to get this desired result use query like:
SELECT * FROM ‘myTable’ WHERE b=’abc’ ORDER BY ABS(price) ASC
here price is number field.