SQLite Forum

Not understanding a subquery - Some guidance?
The LIMIT clause goes at the end.  After DESC.

The way around you put it, SQLite would do the limit first, making it choose one random row of the results first, and only then apply DESC to the one row it has, which would do nothing.