Getting the bottom of a list

[timely]

Ok, I know for getting the top 50 files I would do this:

Select Top 50 a, b, c
from data

but how I get the bottom 50?

 

[JohnDTampaBay]

Your syntax, while technically correct, will not return reliable results. There is no order to SQL Server data, so the only way to get a reliable TOP # is to supply an ORDER BY clause. Having said that, to obtain the rows from the bottom of a result set, switch the ORDER BY clause from DESC to ASC or ASC to DESC, depending on how it is currently defined.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.