How do I select last 5 rows in a table without sorting?

by

This is just about the most bizarre query I’ve ever written, but I’m pretty sure it gets the “last 5” rows from a table without ordering:

select * 
from issues
where issueid not in (
    select top (
        (select count(*) from issues) - 5
    ) issueid
    from issues
)

Note that this makes use of SQL Server 2005’s ability to pass a value into the “top” clause – it doesn’t work on SQL Server 2000.

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. SQL server query to output the data shown below
  3. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  4. Find a value anywhere in a database
  5. How do I generate a random number for each row in a T-SQL select?
  6. How to check if a column exists in a SQL Server table
  7. Combine multiple results in a subquery into a single comma-separated value
  8. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  9. Floor a date in SQL server
  10. How to drop a table if it exists?
  11. Create a view with ORDER BY clause
  12. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  13. INSERT INTO vs SELECT INTO
  14. Possible to store value of one select column and use it for the next one?
  15. How FOR XML PATH(”) works when concatenating rows
  16. Date conversion and culture: Difference between DATE and DATETIME
  17. Scheduled run of stored procedure on SQL server
  18. SQL Server ORDER BY date and nulls last
  19. How to remove accents and all chars a..z in sql-server?
  20. SQL Server variable columns name?
  21. What is the Oracle equivalent of SQL Server’s IsNull() function?
  22. SQL Recursive CTE: Finding objects linked by property
  23. Use of Begin / End Blocks and the Go keyword in SQL Server?
  24. PRINT statement in T-SQL
  25. T-sql – determine if value is integer
  26. Convert decimal time to hours and minutes
  27. How to wait for 2 seconds?
  28. How to set value to variable using ‘execute’ in t-sql?
  29. Update SQL with consecutive numbering
  30. Count number of records returned by group by

Leave a Comment