I don't see the logic behind the numbers from 270 and higher in your wished list. But this Select statement will partly do the trick. Explain the "missing" logic, and I will give you a final answer.
Select acctno, acctno%100 from yourtable order by 2,1
>I have a table with records,
>AcctNo
>100
>201
>204
>205
>270
>280
>290
>301
>304
>305
>320
>450
>545
>
>How can I select this table so that account no 201 should be followed by 301, 204 with 304 and 205 with 305.
>
>AcctNo.
>100
>201
>301
>204
>304
>205
>305
>270
>280
>290
>320
>450
>545
>
>Thanks!