ioSamurai ioSamurai - 10 months ago 45
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...)?


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