ioSamurai ioSamurai - 2 years ago 112
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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download