ioSamurai ioSamurai - 1 year ago 100
SQL Question

How to select bottom most rows?

I can do SELECT TOP (200) ... but why not BOTTOM (200)?

Well not to get into philosophy what I mean is, how can I do the equivalent of TOP (200) but in reverse (from the bottom, like you'd expect BOTTOM to do...)?

Answer Source

It is unnecessary. You can use an ORDER BY and just change the sort to DESC to get the same effect.