Finding Nth ID in an Index

• bcronce

  SSCrazy

  Points: 2597

  More actions

  May 13, 2009 at 1:27 pm

  #132271

  I was trying to find a way to find out the ID for specified position in an index

  Lets say an index was of these numbers and sorted of course

  1234

  1456

  100000

  120000

  800000

  ...

  And I wanted the 3rd ID in that index, which would be 100000

  Essentially, I want to treat the index like an Array

• Adam Wilbur

  SSCertifiable

  Points: 7001

  More actions

  May 15, 2009 at 3:00 pm

  #995703

  Like so...

  select top 1 ID

  from (select top 5 ID

  from table1

  order by ID ASC) t

  order by ID desc

  
  
  A.J.
  DBA with an attitude