SQL Server Performance

Do a query to see the last row of a table

Discussion in 'T-SQL Performance Tuning for Developers' started by Cesar, Mar 11, 2004.

  1. Cesar New Member

    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
  2. gaurav_bindlish New Member

    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
  3. Cesar New Member

    Good !, thank you

Share This Page