How to read the last row with SQL Server

by

If you’re using MS SQL, you can try:

SELECT TOP 1 * FROM table_Name ORDER BY unique_column DESC

More Related Contents:

  1. SQL Server dynamic PIVOT query?
  2. SQL Server – Best way to get identity of inserted row?
  3. SQL Server Process Queue Race Condition
  4. Is the NOLOCK (Sql Server hint) bad practice?
  5. SQL Server 2005 Pivot on Unknown Number of Columns
  6. SQL – Subtracting a depleting value from rows
  7. Get all table names of a particular database by SQL query?
  8. Stored procedure or function expects parameter which is not supplied
  9. Pass table as parameter into sql server UDF
  10. SQL Server Convert Varchar to Datetime
  11. There are no primary or candidate keys in the referenced table that match the referencing column list in the foreign key
  12. OPTION (RECOMPILE) is Always Faster; Why?
  13. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  14. How to set variable from a SQL query?
  15. Case in Select Statement
  16. Split function in SQL Server 2008
  17. SQL – Query to get server’s IP address
  18. Remove numbers from string sql server
  19. T-SQL How to create tables dynamically in stored procedures?
  20. What is the equivalent of ‘describe table’ in SQL Server?
  21. Modify Default value in SQL Server
  22. Unordered results in SQL
  23. Using PIVOT in SQL Server 2008
  24. Produce DISTINCT values in STRING_AGG
  25. sql group by only rows which are in sequence
  26. Function in SQL Server 2008 similar to GREATEST in mysql?
  27. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  28. Query times out from web app but runs fine from management studio
  29. Add a column to existing table and uniquely number them on MS SQL Server
  30. What is the most appropriate data type for storing an IP address in SQL server? [duplicate]

Leave a Comment