SQL Server SELECT LAST N Rows

by

You can get SQL server to select the last N rows with the following query:

select * from tbl_name order by id desc limit N;

More Related Contents:

  1. Multiple INSERT statements vs. single INSERT with multiple VALUES
  2. Why is a UDF so much slower than a subquery?
  3. When using GETDATE() in many places, is it better to use a variable?
  4. I dont know sql syntax for my table [closed]
  5. CROSS JOIN vs INNER JOIN in SQL
  6. How to cast the DateTime to Time
  7. How can I schedule a job to run a SQL query daily?
  8. How to generate a range of numbers between two numbers?
  9. INNER JOIN vs LEFT JOIN performance in SQL Server
  10. Reset identity seed after deleting records in SQL Server
  11. How to avoid the “divide by zero” error in SQL?
  12. Generate Dates between date ranges
  13. Real life example, when to use OUTER / CROSS APPLY in SQL
  14. How to print VARCHAR(MAX) using Print Statement?
  15. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  16. Common Table Expression, why semicolon?
  17. T-SQL split string based on delimiter
  18. Counting DISTINCT over multiple columns
  19. SQL Server 2008: how do I grant privileges to a username?
  20. How do I find duplicates across multiple columns?
  21. Favourite performance tuning tricks [closed]
  22. sql varchar(max) vs varchar(fix)
  23. How to check which locks are held on a table
  24. How do I prevent a database trigger from recursing?
  25. TSQL – How to use GO inside of a BEGIN .. END block?
  26. SQL take just the numeric values from a varchar
  27. Backup a single table with its data from a database in sql server 2008
  28. COALESCE Function in TSQL
  29. Try_Convert for SQL Server 2008 R2
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment