Problem solve
Get help with specific problems with your technologies, process and projects.
Limiting the number of records in a SELECT statement
How do I limit the number of records in a SELECT statement in DB2 SQL? Something similar to the TOP command in SQL?
As of DB2 Version 7 you can use the FETCH FIRST n ROWS ONLY clause. By appending this clause to your SQL SELECT...
statement you will limit the number of rows returned to the value specified for "n". For example, the following SQL statement will limit the number of rows returned to 10:
SELECT FIRSTNAME, LASTNAME, ADDRESS, CITY, STATE, ZIP FROM CUSTOMER WHERE ACCTNO > 10 FETCH FIRST 10 ROWS ONLY;
For More Information
- Dozens more answers to tough DB2 questions from Craig Mullins are available.
- The Best IBM DB2 Web Links: tips, tutorials, scripts, and more.
- Have a DB2 tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical DB2 questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
Start the conversation
0 comments