Use case
LIMIT -10
- return 10 last records (regardless of total number of records).
Can be combined with negative offset (but not with positive offset).
Describe the solution you'd like
Just implement it.
Describe alternatives you've considered
SELECT * (SELECT ... ORDER BY x DESC LIMIT 10) ORDER BY x ASC
But it's more cumbersome.
Use case
LIMIT -10- return 10 last records (regardless of total number of records).
Can be combined with negative offset (but not with positive offset).
Describe the solution you'd like
Just implement it.
Describe alternatives you've considered
SELECT * (SELECT ... ORDER BY x DESC LIMIT 10) ORDER BY x ASCBut it's more cumbersome.