advanced code snippet search

Posted By

pauliehaha on 02/09/09


Tagged


Versions (?)

SELECT LIMIT

 / Published in: SQL
 
Expand | Embed | Plain Text 
  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.