my see quill queer we

I have a table with one integer field (num) containing numbers ranging from one to a 16 million. I need to sort the table from how far they are from a specific number.

So if I have the number 90, 95, 100, 102, 107, 200 and 100 is the start number then the output would be.

num
---
100
102
95
107
90
200

Is this possible?

No. You need to upgrade to Oracle 11g for Enterprise Starship Class arithmetical querying capabilities. Type UPGRADE into your mysql console and an Oracle representative will arrive to take your check for $50000 and provide you with Expert Database DBA Administration assistance.