Is there an SQL Standard Keyword similar to First only for Last

Question

I would like to know if there is a keyword similar to fetch first provided here for selecting the last rows?

I know something similar can be done by changing the sorting from say ascending to descending and use that, but I want to avoid that for now.

Possible duplicate of [How to select the last record of a table in SQL?](https://stackoverflow.com/questions/5191503/how-to-select-the-last-record-of-a-table-in-sql) — cнŝdk, Nov 12 '17 at 14:15

score 1 · Answer 1 · answered Nov 12 '17 at 14:13

There is no fetch last.

One solution is to reverse the sort order . . . but that reverses the results. So, two sorts are necessary:

select t.*
from (select t.*
      from t
      order by . . . desc
      offset 0 fetch first 10 rows only
     ) t
order by . . . asc;

1 Answers1