Quick Access Query

• Topher

  SSCommitted

  Points: 1763

  More actions

  August 18, 2008 at 10:28 am

  #72902

  I need to be able to display a single result which has been posted the most recent.

  So, say I have ten entries w/ a time stamp on each, I need to display only the most recent one....

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  August 18, 2008 at 10:42 am

  #859569

  this should get you the latest value based on time-stamp

  SELECT top 1 *

  FROM YourTable

  ORDER BY timestamp DESC;