Taking the second last row with only one select in SQL Server?

by

To get the 2nd last row in one select:

SELECT TOP 1 * From
(select Top 2 * from Cinema ORDER BY CinemaID DESC) x                     
ORDER BY CinemaID

It’s really only “one” select because the outer select is over only 2 rows.

More Related Contents:

  1. The order of a SQL Select statement without Order By clause
  2. Select columns from result set of stored procedure
  3. SQL Server: SELECT only the rows with MAX(DATE)
  4. What does “ORDER BY (SELECT NULL)” mean?
  5. SQL Server – join rows into comma separated list
  6. How can foreign key constraints be temporarily disabled using T-SQL?
  7. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  8. How to create materialized views in SQL Server?
  9. How can I clear the SQL Server query cache?
  10. SQL Server Random Sort
  11. SQL Server database backup restore on lower version
  12. Add a new table column to specific ordinal position in Microsoft SQL Server
  13. How do you specify a different port number in SQL Management Studio?
  14. How to set monday as first day of week in SQL Server
  15. How do I flush the PRINT buffer in TSQL?
  16. SQL Server Login error: Login failed for user ‘NT AUTHORITY\SYSTEM’
  17. VarBinary vs Image SQL Server Data Type to Store Binary Data?
  18. Drop primary key using script in SQL Server database [duplicate]
  19. OR Operator Short-circuit in SQL Server
  20. T-SQL XOR Operator
  21. SQL Server: convert ((int)year,(int)month,(int)day) to Datetime [duplicate]
  22. How to wait for 2 seconds?
  23. Can I have a foreign key referencing a column in a view in SQL Server?
  24. How do you add a NOT NULL Column to a large table in SQL Server?
  25. 7645 Null or empty full-text predicate
  26. SQL Server backup/restore vs. detach/attach
  27. How does SQL Server decide format for implicit datetime conversion?
  28. Error converting data types when importing from Excel to SQL Server 2008
  29. EAV over SQL Server
  30. The Best Way to shred XML data into SQL Server database columns

Leave a Comment