SQLite Forum

Change Default ORDER BY to descending.

Change Default ORDER BY to descending.

(1) By anonymous on 2021-03-23 22:10:29 [link] [source]

Which files in the source codes contain the code for ORDER BY?
I want to set my default ORDER BY to descending order. I think there is not only one file to change.
Please help!
Thanks in advance!

(2) By Larry Brasfield (larrybr) on 2021-03-23 22:20:43 in reply to 1 [source]

You might consider a custom collation. It would be a collation shim, just inverting a collation of your choice. The bonus would be cluing readers of your SQL that something funny is going on.