• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

SQL server

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

Selet top works...not bottom
0
lrbrister
Asked:
lrbrister
  • 2
1 Solution
 
QPRCommented:
select the top but order by something desc

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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now