We want to return records, from a select statement, in sequential order (1,2,3,etc..). Currently we are using an order by statement at the end, however it orders them by first digit, then second digit, etc. (1,10,12). How can we set this up correctly?
select distinct id
from Location
order by id asc