Link to home
Start Free TrialLog in
Avatar of Larry Brister
Larry BristerFlag for United States of America

asked on

SQL server

How do I select the BOTTOM x number from a list?

Selet top works...not bottom
ASKER CERTIFIED SOLUTION
Avatar of QPR
QPR
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Larry Brister

ASKER

QPR:
Doesn't taht still give me the top 50 of x million but inn descending order?
lrbrister:
that will select the TOP 50 from the BOTTOM upwards... i.e. BOTTOM 50
nope because you are asking for the id (or some other sequential value) in descending order you will get the bottom 50