Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL server

Posted on 2007-12-03
4
182 Views
Last Modified: 2010-03-19
How do I select the BOTTOM x number from a list?

Selet top works...not bottom
0
Comment
Question by:lrbrister
  • 2
4 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
ID: 20399674
select the top but order by something desc

select top 50 *
from mytable
order by idnumber desc
0
 

Author Comment

by:lrbrister
ID: 20400077
QPR:
Doesn't taht still give me the top 50 of x million but inn descending order?
0
 
LVL 25

Expert Comment

by:imitchie
ID: 20400193
lrbrister:
that will select the TOP 50 from the BOTTOM upwards... i.e. BOTTOM 50
0
 
LVL 29

Expert Comment

by:QPR
ID: 20400314
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question