andrew Sullivan
Reputation: 4084
select last row of table
How to select last row of table in SQL SERVER 2005
Upvotes: 0
Views: 1019
Answers (1)
SQLMenace
Reputation: 134923
In general like this
select top 1 *
from table
order by SomeColumn desc
Upvotes: 3
Related Questions
- How to select the last record of a table in SQL?
- How to read the last row with SQL Server
- Select the last row in a SQL table
- How to retrieve the last row of a table?
- How to select a column of the last row in the table?
- Selecting last occurence of row from table
- SQL Server 2005 Getting the last record of a column
- How to get (One Before Last) row in SQL Server 2005
- Selecting the very last record of the returned table
- How to select a last row - Column1 Value in SQL