So... So you think you can sort?

Like with many articles, this one found its origin in an application bug. A developer came to me saying that the ORDER BY in his SQL gave incorrect results. After some investigation, this article was the result. ORDER BY is so easy to add at the end ...