Selecting the newest row in T-SQL

Question

I have a database table containing a column called timestamp, which stores the system time for each of the rows inserted.

How do I select the row with the latest timestamp, i.e. the row that was inserted last?

Answer 1

SELECT TOP 1 * FROM [tableName] ORDER BY timestamp DESC