Product:

DB2 database

Issue:

How list only a few rows of data?

Solution:

In your SQL tool, enter something like this:

SELECT * FROM schemaname.tablename WHERE id = 1 FETCH FIRST 100 ROWS ONLY

 

More Information:

https://www.razorsql.com/articles/db2_limit_query.html

SQL FETCH: Retrieving Data In Database Cursors

https://www.dbvis.com/thetable/sql-limit-clause-complete-handbook/ 

https://www.w3schools.com/sql/sql_top.asp 

https://dbeaver.com/docs/dbeaver/Navigation/