How to get the last row from a table in SQL Server?

by

Database tables are unsorted by nature. There is no last row in the table.

If there is a clustered index, The records are stored in the same order as the clustered index, but that does not mean that’s the order of the rows – Unless you specify an order by clause in your query, no database guarantees the order of the rows returned by said query.

From Wikipedia page on tables (emphasis mine):

In terms of the relational model of databases, a table can be considered a convenient representation of a relation, but the two are not strictly equivalent. For instance, an SQL table can potentially contain duplicate rows, whereas a true relation cannot contain duplicate tuples. Similarly, representation as a table implies a particular ordering to the rows and columns, whereas a relation is explicitly unordered. However, the database system does not guarantee any ordering of the rows unless an ORDER BY clause is specified in the SELECT statement that queries the table.

See also Aaron Betrand’s Bad habits to kick : relying on undocumented behavior, the paragraph titled “Ordering without an ORDER BY”:

… I want to make it quite clear: ordering is arbitrary unless you use an ORDER BY clause. You should never, ever, ever rely on the ordering you observe in a query without an ORDER BY — and you should only issue a query without an ORDER BY clause if you truly do not care what order the results come back. In such a case, you may as well imagine that the rows are going to come back in a different, random order each time, even though that is not truly the case (random has a meaning completely separate from arbitrary, but like I said, just imagine).

More Related Contents:

  1. hide/remove header and footer
  2. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  3. SQL Server: SELECT only the rows with MAX(DATE)
  4. Floor a date in SQL server
  5. Create a view with ORDER BY clause
  6. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  7. INSERT INTO vs SELECT INTO
  8. Possible to store value of one select column and use it for the next one?
  9. LEN function not including trailing spaces in SQL Server
  10. How to view transaction logs in SQL Server 2008 [closed]
  11. Scheduled run of stored procedure on SQL server
  12. SQL Server ORDER BY date and nulls last
  13. SSRS 2014 report deploy issue
  14. Best way to implement an audit trail in SQL Server?
  15. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  16. SqlDataAdapter.Fill method slow
  17. What happens to the primary key Id when it goes over the limit?
  18. Will GETUTCDATE() return the same value if used twice in the same statement?
  19. Convert decimal time to hours and minutes
  20. Create table (structure) from existing table
  21. Importing excel files having variable headers
  22. SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
  23. How can I make SQL Server return FALSE for comparing varchars with and without trailing spaces?
  24. “Prevent saving changes that require the table to be re-created” negative effects
  25. How to change column datatype in SQL Server database without losing data?
  26. Convert UTC Milliseconds to DATETIME in SQL server
  27. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  28. How to make a passthrough / passthru query editable?
  29. To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher
  30. Tool for Scripting Table Data

Leave a Comment