Do a query to see the last row of a table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Do a query to see the last row of a table

Hi! How can I do a query in the ‘Query Analyzer’ so that I can see the fields of the last row of a table? Thanks,
Cesar
SELECT TOP 1 * FROM myTable
ORDER BY colOrderrByColumn DESC Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Good !, thank you
]]>