Emulate MySQL LIMIT clause in Microsoft SQL Server 2000

by

Here is another solution which only works in Sql Server 2005 and newer because it uses the except statement. But I share it anyway.
If you want to get the records 50 – 75 write:

select * from (
    SELECT top 75 COL1, COL2
    FROM MYTABLE order by COL3
) as foo
except
select * from (
    SELECT top 50 COL1, COL2
    FROM MYTABLE order by COL3
) as bar

More Related Contents:

  1. Stored Procedure with optional “WHERE” parameters
  2. update columns values with column of another table based on condition [duplicate]
  3. How do I list all the columns in a table?
  4. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  5. How do I create a table alias in MySQL
  6. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  7. Efficiently convert rows to columns in sql server
  8. How can I do an UPDATE statement with JOIN in SQL Server?
  9. Why does NULL = NULL evaluate to false in SQL server
  10. The multi-part identifier could not be bound
  11. How to insert a line break in a SQL Server VARCHAR/NVARCHAR string
  12. How do I make a row generator in MySQL?
  13. MySQL number of items within “in clause”
  14. T-SQL – Insert Data into Parent and Child Tables
  15. TSQL PIVOT MULTIPLE COLUMNS
  16. Is there an alternative to TOP in MySQL?
  17. Find the smallest unused number in SQL Server
  18. Is it possible to have an indexed view in MySQL?
  19. MS SQL “ON DELETE CASCADE” multiple foreign keys pointing to the same table?
  20. Is it possible to run multiple DDL statements inside a transaction (within SQL Server)?
  21. Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
  22. Should I use SQL_Variant data type?
  23. Log record changes in SQL server in an audit table
  24. How can I backup a remote SQL Server database to a local drive?
  25. Getting the Id of a row I updated in Sql Server
  26. Zero SQL deadlock by design – any coding patterns?
  27. UNION ALL vs OR condition in sql server query
  28. What does collation mean?
  29. Try_Convert for SQL Server 2008 R2
  30. SQL Server variable scope in a stored procedure

Leave a Comment