SQL server

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

Selet top works...not bottom
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
QPRCommented:
select the top but order by something desc

select top 50 *
from mytable
order by idnumber desc
0
 
Larry Bristersr. DeveloperAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.