Yes: retrieve all the records and assemble the list in memory.

My understanding is that it's possible, but not fast. A quick google search turned up this page, but I'm sure there are more https://stackoverflow.com/questions/515749/how-do-i-sort-a-l...

I seem to recall seeing _something_ more elegant than a linked list for this type of thing, but I don't recall what is what, offhand.

All the answers on that page, except perhaps the Oracle one which uses a technique in not familiar with, are using recursion in CTEs