T-SQL for "Last n records" in a table

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  September 8, 2001 at 2:12 pm

  #77700

  What's an easy way to do

  "select bottom 5 * from..."

  to see the last 5 records in a table?

  Of course, the use of bottom isn't valid T-SQL(though, in it's place, TOP is)

  TIA,

  Bill

• satishkartan

  Grasshopper

  Points: 17

  More actions

  September 8, 2001 at 2:49 pm

  #418105

  sort the table in the descending order by using " DESC" keyword and do a select TOP 5

• don1941

  SSCarpal Tunnel

  Points: 4183

  More actions

  December 8, 2002 at 5:03 pm

  #443640

  way to obvious an answer. I wish I'd thought of it.