Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

SELECT LIMIT


 / Published in: SQL
 

  1. -- Select a limit (like mySQL LIMIT) i.e. this selects rows 95-100
  2. SELECT *
  3. FROM
  4. (
  5. SELECT TOP 5 *
  6. FROM
  7. (
  8. SELECT TOP 100 *
  9. FROM [TABLE]
  10. ORDER BY 1 ASC
  11. ) AS tbl1 ORDER BY 1 DESC
  12. ) AS tbl2 ORDER BY 1 ASC

Report this snippet  

You need to login to post a comment.