Equivalent of LIMIT for DB2

by

Using FETCH FIRST [n] ROWS ONLY:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.perf/db2z_fetchfirstnrows.htm

SELECT LASTNAME, FIRSTNAME, EMPNO, SALARY
  FROM EMP
  ORDER BY SALARY DESC
  FETCH FIRST 20 ROWS ONLY;

To get ranges, you’d have to use ROW_NUMBER() (since v5r4) and use that within the WHERE clause: (stolen from here: http://www.justskins.com/forums/db2-select-how-to-123209.html)

SELECT code, name, address
FROM ( 
  SELECT row_number() OVER ( ORDER BY code ) AS rid, code, name, address
  FROM contacts
  WHERE name LIKE '%Bob%' 
  ) AS t
WHERE t.rid BETWEEN 20 AND 25;

More Related Contents:

  1. SQL update from one Table to another based on a ID match IN db2
  2. An unexpected token “CREATE TRIGGER
  3. Why does the 260 character path length limit exist in Windows?
  4. Equivalent of LIMIT and OFFSET for SQL Server?
  5. Why does MYSQL higher LIMIT offset slow the query down?
  6. Browser Javascript Stack size limit
  7. Maximum number of records in a MySQL database table
  8. How can I programmatically remove the 2 connection limit in WebClient
  9. DB2 Comma Separated Output by Groups
  10. MySQL – UPDATE query with LIMIT
  11. How many levels of pointers can we have?
  12. Is there a memory limit for a single .NET process
  13. How to set a maximum execution time for a mysql query?
  14. How do you enable LIMIT for DELETE in SQLite?
  15. How can I speed up a MySQL query with a large offset in the LIMIT clause?
  16. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  17. How to limit the number of dropzone.js files uploaded?
  18. MySql Query: Select top 3 rows from table for each category
  19. INNER JOIN in UPDATE sql for DB2
  20. What is the email subject length limit?
  21. Regular Expressions in DB2 SQL
  22. PHP: Limit foreach() statement? [closed]
  23. UPDATE with ORDER BY and LIMIT not working in MYSQL
  24. Upper limit in Python time.sleep()?
  25. Rails 3.1 limit user created objects
  26. Prevent PHP script from being flooded
  27. MySQL LIMIT on DELETE statement
  28. DB2 Query to retrieve all table names for a given schema
  29. MongoDB Single Document size limit is 16MB
  30. Why is Unicode restricted to 0x10FFFF?

Leave a Comment