bottom 100

• Ian Cockcroft

  Old Hand

  Points: 305

  More actions

  January 24, 2006 at 2:32 am

  #92860

  if top 100 returns the first 100 records in a table, how do I get the last 100 records in a table? Can use the key but is there a converse to top 100?

• allen davidson

  SSCertifiable

  Points: 7042

  More actions

  January 24, 2006 at 2:47 am

  #616604

  use TOP 100 and ORDER BY DESC?

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  January 24, 2006 at 3:10 am

  #616609

  'Top 100' by itself doesn't return the 'first', it returns the 'first found by the query'.

  If 'first' is implied by some kind of order, you must use ORDER BY on that column.

  --=== 'First'

  select top 10 error from master..sysmessages order by error asc

  --=== 'Last'

  select top 10 error from master..sysmessages order by error desc

  /Kenneth